Excel if function: less than date

Closed
ilovejr
Posts
1
Registration date
Friday February 15, 2013
Status
Member
Last seen
February 15, 2013
- Feb 15, 2013 at 01:45 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 15, 2013 at 04:46 AM
Hello, I need a what if formula to satisfy the following:

if date in K34 is before 23 Nov 2012, then AB34 = yes and so on.. i.e date in K35> 23 Nov 12 then AB35 = no

Thank you!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Feb 15, 2013 at 04:46 AM
look into IF function
1