Excel Date Formula (IF)

[Closed]
Report
Posts
2
Registration date
Thursday September 8, 2016
Status
Member
Last seen
September 8, 2016
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
Hello,
I'm in need of some assistance with an excel date formula.

I'm need to look at 2 cells in the same row which contain dates or may be NULL and determine if either of them are greater than a hard coded date..... Null value would result in a "No" result.

Col(a) Col(b) Col(c)*Formula/Result goes in col c
Row(1) 01/03/2015 12/07/2010 Yes
Row(2) 12/07/2016 No
Row(3) 12/01/2015 12/07/2011 No
Row(4) 01/03/2016 Yes

If row(1)/col(a) or row(1)/col(b) are less than "12/31/2015" write "Yes" or "No" in row(1)/col(c)


Any help that anyone could provide with my EXCEL formula questions/issue would be greatly appreciated. Thanks in advance, JackSoup

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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