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" 127

A few words of thanks would be greatly appreciated. Add comment

CCM 6103 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.
thanks help me too