Highlighting Due Dates

[Tyler7557]

Hi,

I am trying to highlight due dates on a spreadsheet, but am confused as to how to use the TODAY function along with the conditional formatting (if that is even the most appropriate action). If the Expected Completion Date (E) surpasses the Due Date (D) or TODAY, I would like Column G to say "Late".

Column D: Due Date
Column E: Expected Completion Date
Column F: Completion Date
Column G: On Time (=IF(E5-D5>0,"Late","On Time")

Currently, it is telling me if a project is "On Time" or "Late", but I would like today's date to also have an influence, as this will be a shared document that I cannot update everyday.

Any assistance is greatly appreciated, even if I have to re-do everything I've done today lol.

 

[Akashwani]

Hi Tyler.

Is this what you mean?....

Excel Workbook
	C	D	E	F	G	H	I	J
1		Due Date	Expected Completion Date	Completion Date	On Time		CF Formula
2		16/06/2013	19/06/2013	20/06/2013	Late		TRUE
3		18/06/2013	18/06/2013	20/06/2013	On Time		FALSE
4
Sheet3

Ak

 

[Gideon1973]

Can you just add >= to your formula: =IF(E2-D2 >= 0,"Late","On Time")

Does that work for you?

EDIT: I didn't consider the "today" option as Akashwani did. I think that one is the ticket...

 

[Tyler7557]

I am going to play with this and see if the outcome works - thank you kindly for your help!

 

[Akashwani]

**Duplicated reply!!**

 

[Tyler7557]

Can you just add >= to your formula: =IF(E2-D2 >= 0,"Late","On Time")

Does that work for you?

EDIT: I didn't consider the "today" option as Akashwani did. I think that one is the ticket...

Thank you for your help nonetheless! I tried yours and it works better than what I had previously, but the TODAY function will make it easier for me to share the document. Thanks again!

 

[Tyler7557]

The only issue I seem to have is if the project will actually be on time. If it will be completed on the due date, it says "Late". Any way to change that, or does that make it too complicated?