Formula Question: "IF" function with date
Solved/Closed
Related:
- Formula Question: "IF" function with date
- Unique text formula question in excel ✓ - Forum - Excel
- EXCEL: Nested IF formula question ✓ - Forum - Excel
- Functions and formula of the electronic spreadsheet - Articles
- What should you do to enter common data, formulae, functions and formatting effects in multiple sheets? - Guide
- Function Formula Date and Text ✓ - Forum - Excel
1 reply
Mazzaropi
Sep 22, 2016 at 03:02 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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