date formula

[msk7777]

I need help with a date formula problem, I tried to search the forums but found no help. Its pretty simple I am sure, but in column C I have Date Due, and column E I have Date Paid. I simply want Column G to tell me if the Date Paid is after the Due Date, yes=late, no=On Time. Hope someone can help. Thanks!

msk7777

 

[pgc01]

Hi msk7777

Try in G1

=IF(E1>C1,"Late","On Time")

HTH
PGC

 

[msk7777]

thanks, worked perfectly!

 

[msk7777]

is there something I could add to it if the cells are blank to display "Undertermined"

 

[pgc01]

Hi again

Try:

=IF(OR(E1="",C1=""),"Undertermined",IF(E1>C1,"Late","On Time"))

HTH
PGC

 

[msk7777]

I'm sorry, I put that in and it keeps putting "Late" as the result. Even if both cells are blank it still says "Late".

 

[msk7777]

Nevermind figured out the problem, thanks that works great! You were a big help!