Formula Question: "IF" function with date [Solved]

Ask a question Kim - Latest answer on Sep 22, 2016 03:09PM
I am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/30/16.
Thanks in advance!
See more 
moins plus
Kim, Good afternoon.

Try to use:

P1 -->
=IF(AND(B1>DATEVALUE("07/30/2016"), E1<DATEVALUE("07/31/2016")),"Yes","")

Is this what you want?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Kim- Sep 22, 2016 03:09PM
Perfect! Thank you!
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!