Ask a question Report

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

Kim - Sep 22, 2016 at 01:27 PM - Latest reply: Kim

- Sep 22, 2016 at 03:09 PM

Excel Ask a question Report

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!

Formula Question: "IF" function with date
Date formula question » Forum - Excel
Apply an IF Function Using Dates and Text » How-To - Excel
EXCEL: Nested IF formula question (Solved) » Forum - Excel
Excel 2003 IF Function using Dates & Text (Solved) » Forum - Excel
Excel "IF" function w/ date in test cell [Solved] (Solved) » Forum - Excel

2 replies

Report Respond to Mazzaropi

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Sep 22, 2016 at 03:02 PM

Thank you

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

Kim - Sep 22, 2016 at 03:09 PM

Perfect! Thank you!

Ask a question

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

Your reply