Dates- Updating to show the status

[WTB]

Hi,

I've got a spreadsheet with various due dates, i want it to be able to update automatically so it shows the current status of any of the given dates. I've attached an example with the status column showing what i want it to show, but how can i apply a formula to this so it does it automatically. I was trying to apply an IF formula to it but it has too many variables and i can't get it to take into account if it has already been received. Any help would be much appreciated!

Regards

WTB

[Richard Buttrey]

Hi,

In E5 copied down

Please Login or Register  to view this content.

incidentally there was a typo. E8 should be overdue not blank.

HTH

[WTB]

Thanks! Thats exactly what i want! The typo in E8 should have been 1/4/10, well spotted!

Thanks again

WTB

[WTB]

Richard,

I've found a small problem with the formula you gave me if i put a received date in before the due date it returns blank, when i want it to return paid. Any ideas? I've attached a modified example to explain

Regards

Chris

[Richard Buttrey]

Hi Chris,

Perhaps

Please Login or Register  to view this content.

HTH