Excel if function: less than date

[Closed]
Report
Posts
1
Registration date
Friday February 15, 2013
Status
Member
Last seen
February 15, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
look into IF function
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month