# Past due dates

#### Problownchild

##### New Member
Hello all, i am using a simple spread sheet to show upcoming due dates for renewals, that part i have, but i need a formula to show past due dates. thanks for any and all responses.
Michael

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### BAlGaInTl

##### Well-known Member
Hello all, i am using a simple spread sheet to show upcoming due dates for renewals, that part i have, but i need a formula to show past due dates. thanks for any and all responses.
Michael

Assuming that Past due means that the date due is less than the current date...

If my Due date were in C1

=IF(C1 < TODAY(),"Past Due","OK")

If you are going to do a lot of these, you may want to put =TODAY() in a cell somewhere and then reference that instead.

So if we pretend that I put =TODAY() in D1, the formula becomes

=IF(C1 < D1,"Past Due","OK")

#### Problownchild

##### New Member
thanks for the reply, but to no avail....i am using 3 conditions, 1 was using your formula, 2 was =(j8-today())<30, and 3 was =(j8-today())<90. when i use your formula i get an error message and the cell does not change to red. i know that it is something that i am missing, sorry for being slow.
Michael

#### barry houdini

##### MrExcel MVP
Try making condition 1

=J8< TODAY()

#### Problownchild

##### New Member
shazam, i believe this working, thanks for the knowledge.
Michael

Replies
2
Views
541
Replies
0
Views
151
Replies
4
Views
513
Replies
1
Views
246
Replies
3
Views
211

1,190,798
Messages
5,982,981
Members
439,810
Latest member
phobo3s

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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.
Go back