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 4478 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!
Related:

1 response

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