Excel "IF" function w/ date in test cell [Solved/Closed]

- Nov 22, 2009 at 11:00 AM - Latest reply:  salim - Apr 29, 2018 at 08:16 AM

I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho, if it doesn't then I want it to calculate the difference between two cells that are populated with dates. The formula that I have been trying to get to work is shown below...any thoughts are greatly appreciated!

See more 

2 replies

Best answer
Registration date
Sunday June 14, 2009
Last seen
July 30, 2015
Nov 22, 2009 at 10:11 PM
Thank you
something like this


Thank you, venkat1926 120

Something to say? Add comment

CCM has helped 1702 users this month

Thank you. It saved my job.
Thank you very much it saved lot of time
Thanks, U really help me out.
Thank you
wow, great formula.