Previous Topic Next Topic

Excel "IF" function w/ date in test cell

Solved/Closed

Mike in PA - Updated on May 28, 2018 at 09:12 AM
salim - Apr 29, 2018 at 08:16 AM

Hello,

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!

=IF(E22="mmddyyyy","Done",D22-H22)

Related:

Excel if date
If date excel - Best answers
If formula for dates - Best answers
Excel mod apk for pc - Download - Spreadsheets
How to change date format in excel - Guide
Vat calculation excel - Guide
Kernel for excel repair - Download - Backup and recovery
Excel add days to date - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Updated on Nov 29, 2018 at 05:16 PM

You should write something like this :

=IF(E22=DATE(2009,11,2),"done",D22-H22)

Japs
Feb 24, 2013 at 08:18 PM

wow, great formula.
thanks

MEME
Mar 17, 2017 at 01:20 PM

Thank you. It saved my job.

Rc
Updated on Nov 24, 2017 at 04:39 AM

Thank you very much it saved lot of time

Areyqyu
Updated on Dec 27, 2017 at 02:13 AM

Thanks, U really help me out.

salim
Apr 29, 2018 at 08:16 AM

thanks help me too

Similar discussions

Find word within cell & put value in adjacent

Copy data onto sheet only if cell has text

If a cell contains any text then add a value

If cell = date return yes or no.

Excel - IF function with multiple words

Conditional formatting: change fontcolor based on another cell

Subscribe To Our Newsletter!

trending

Related