Excel Date Formula (IF)
Closed
JackSoup
Posts
1
Registration date
Thursday 8 September 2016
Status
Member
Last seen
8 September 2016
-
8 Sep 2016 à 17:00
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 9 Sep 2016 à 07:43
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 9 Sep 2016 à 07:43
Related:
- If date excel
- Excel if date - Best answers
- Excel if function date - Best answers
- Excel mod apk for pc - Download - Spreadsheets
- How to change date format in excel - Guide
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Excel add days to date - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
9 Sep 2016 à 07:43
9 Sep 2016 à 07:43
JackSoup, Good morning.
Try to use it:
a) Your date 12/31/2015 is in a CELL: M1
C1 --> =IF(OR(AND(A1<>"",A1<$M$1),AND(B1<>"",B1<$M$1)),"YES","NO")
b) If you want to use a date in a formula.
C1 -->
=IF(OR(AND(A1<>"",A1<DATEVALUE("12/31/2015")), AND(B1<>"",B1<DATEVALUE("12/31/2015"))),"YES","NO")
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use it:
a) Your date 12/31/2015 is in a CELL: M1
C1 --> =IF(OR(AND(A1<>"",A1<$M$1),AND(B1<>"",B1<$M$1)),"YES","NO")
b) If you want to use a date in a formula.
C1 -->
=IF(OR(AND(A1<>"",A1<DATEVALUE("12/31/2015")), AND(B1<>"",B1<DATEVALUE("12/31/2015"))),"YES","NO")
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
