Excel Date Formula (IF)
Closed
JackSoup
Posts
1
Registration date
Thursday September 8, 2016
Status
Member
Last seen
September 8, 2016
-
Sep 8, 2016 at 05:00 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 9, 2016 at 07:43 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 9, 2016 at 07:43 AM
Related:
- Excel Date Formula (IF)
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel apk for pc - Download - Spreadsheets
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 9, 2016 at 07:43 AM
Sep 9, 2016 at 07:43 AM
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
