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

Question

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

Report

Kim - Sep 22, 2016 at 01:27 PM
Kim - Sep 22, 2016 at 03:09 PM

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!

Excel if date
If date excel - Best answers
Excel if formula with dates - Best answers
Transfer data from one excel worksheet to another automatically - How-To - Excel
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Excel @ in formula ✓ - Forum - Excel
Number to words in excel without vba ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software

1 reply

Ask a question

Mazzaropi · Answer 1 · 2016-09-22T15:02:31-0400

Answer 1 / 1

Mazzaropi

Posts: 1927
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: June 17, 2021

143
Sep 22, 2016 at 03:02 PM

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!

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

1 reply

Your reply

Subscribe To Our Newsletter!