Formula Question: "IF" function with date
Solved/Closed
Related:
- Formula Question: "IF" function with date
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 22, 2016 at 03:02 PM
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
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
Sep 22, 2016 at 03:09 PM