Excel Date Formula (IF)

Closed
JackSoup Posts 2 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
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
Related:

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
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