Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Report
-
 Kim -
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
Related:

1 reply

Answer 1 / 1
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
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
Report

Perfect! Thank you!
Ask a question