Related:
- Excel if date
- If date excel - Best answers
- Excel if formula with dates - Best answers
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Excel formula bar missing - How-To - Excel
- How to change author in excel - How-To - Excel
- Spell number in excel 2007 indian rupees download ✓ - Forum - Office Software
- Excel mac right click not working ✓ - Forum - MacOS
1 reply
Mazzaropi
- Posts
- 1868
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 15, 2021
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
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
Perfect! Thank you!
Subscribe To Our Newsletter!
