Need help combing these function into a single cell
This formula recalculates the date based off a value in column P
=IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90))
This formula determines the amount of days between today and the new date
This formula enters...
I have been periodically creating a stacked column chart. This now has been divided in 3 sections and so the chart has to follow! I'm sure this should be really simple but I just cant seem to manage it. I eventually got it split into 3 by transposing the data but now I am missing P6 from my...
Hi, Newbie here!
I've built a spreadsheet to track reports that are on track/due or overdue. I've added IF formulas to show the on track/due/overdue items and used conditional formatting to change the cell colour which is working without any problems.
I have chart to show the volume of items...
Hi! This is my first time posting a thread so please be nice to me .. :cry:
I have a workbook with 11 sheets - sheets 1-10 have Due Dates (E7 - E50 = reserved for the due dates even though some sheets only have 3 rows filled with dates). Sheet 11 is supposed to be like a main/front page...
Please find the Loan EMI and Collection table below:
As per EMI Schedule
As per Collection Report
Sum of EMI
I am trying to create a formula that shows the overdue amount based on amount of days overdue. In this case i am looking to sum up the values that are overdue more than 8 to 14 days. The cells that are overdue are marked with a negative sign...
i have a table set out as follows,
Age of Debt
Up to 30 days overdue
31 - 60 days overdue
61 - 90 days...
I have the following formula which is working great (as far as it goes):
=IF(AF6>AA6,"Not due yet",IF(AF6>AA6+7,"~ 7 days late","+ 7 days late"))
AF6 is Last Review Date
AA6 is todays date.
So the formula is looking to show:
If the Last Review date is overdue return one of the messages...
Hello, I am trying to change the values in my Status column to either Overdue, On Track, or Blank.
These will reference my Due Date column.
I have figured out how to have my cell = Overdue or On Track, but am having difficulty adding an additional layer to the formula.
Currently, I have...
Hi I am currently using the following formula to successfully flag up when a person is either due to pay or if they haven't paid by the end of the month when payment was due. When less than 30days the cell shows "due x number of days ago". When over 30 days it shows 'Overdue and the number of...
Hi can anyone help me with the correct formula I need to show the number of days overdue based on data in two other fields.
Field 1 [Date Reqired for Compliance] in which the user inputs the date when someone needs to have responded to a request.
Field 2 [Date Material received] the user...
Long-time lurker; first-time poster. I'm coming up against a bit of a brick wall with my current task and I thought you'd be able to help. My problem is this:
I have a set of data, consisting of a list of names (col A), category A, B or C (col B) and number of days overdue (col C)
Hi, I am new on the form and not very familiar with Macro's.
I found the following macro on the web.
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Dim Path As String
Path = Application.ActiveWorkbook.Path
Set OutApp =...
I am building a report to show my team of buyers which Purchase orders are overdue under each persons name.
The pivot table is pulling from a table of "unprocessed" PO lines. Consolidating the data first by buyer and then PO number. I need to filter due date "= or < current date" and then...
i have a column which is formatted to populate an overdue when a date is less then today. When I drag the formate down it populates overdue as there is no date currently.
How to i I keep the formate however when the source cell is blank the formatted blank remains blank too?
I need a Macro to work out if a range of dates are overdue based on comparing expected delivery date against todays date
There could be any number of rows each week so it will have to perform the calculation over an undetermined range.
If I was to produce an if statement within the...
I have spent fruitless hours on something that I am pretty sure should be straightforward, please help my sanity :confused::confused:
So, I want the...
I currently use the following formula which works well and produces the text either "Due" or "Overdue" if no payment has been entered into that cell for the current Month. If payment is not received anytime between the first and last day of the month "Due" appears, this changes to "Overdue"...