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

Mike in PA - 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 

6 replies

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Nov 22, 2009 at 10:11 PM
something like this

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