I run a maintenance business and I've decided to make an excel sheet that tracks if my technicians are keeping up with their service on a weekly, biweekly, or monthly basis.
I figured the easiest way might be by changing "biweekly" to 14 and "monthly" to 30 like I set up the true/false...
Hi there,
I want to create a worksheet that tells me how much time has past or is there until action is needed.
So there is an appointment which needs to be taken every 2 years.
I want to see how much time in months is left until they need to take it again or how many months day are overdue...
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
=ABS(AN16-TODAY())
This formula enters...
Hi
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...
Dear All,
Please find the Loan EMI and Collection table below:
<colgroup><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col></colgroup><tbody>
As per EMI Schedule
As per Collection Report
Account Number
Month Number
Sum of EMI
Cumulative EMI
Due Date
Sum of...
Hello
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...
Hi There,
Please help!
i have a table set out as follows,
<colgroup><col><col><col><col><col><col></colgroup><tbody>
A
B
C
D
E
1
Age of Debt
Business
Person
Govt
Other
2
Current
0%
0%
5%
0%
3
Up to 30 days overdue
10%
5%
5%
0%
4
31 - 60 days overdue
20%
5%
20%
0%
5
61 - 90 days...
Hi there,
I'm in need of a code that will make the cells flash red/white once the cell contains a text value of 'Overdue' in the Q4:Q11000 range.
Any ideas?
Hi all
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...
Hi all,
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)
I...
Hi, I am new on the form and not very familiar with Macro's.
I found the following macro on the web.
Sub SendEmailfromOutlook()
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Dim Path As String
Path = Application.ActiveWorkbook.Path
Set OutApp =...
Hi
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...
Should be easy. Column "A" has a DUE DATE. Based on the date as of TODAY(). Is it late or not? I can deal with simple true or false. It's just not working.
Hi,
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?
sam
Hello,
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.