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


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 

1 reply

Best answer
approved by Jean-François Pillou on Nov 29, 2018
Registration date
Sunday June 14, 2009
Last seen
July 30, 2015
Thank you
You should write something like this :


Say "Thank you" 121

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 4565 users have said thank you to us this month

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