Previous Topic Next Topic

Excel if function: less than date

Closed
ilovejr Posts 1 Registration date Friday 15 February 2013 Status Member Last seen 15 February 2013 - 15 Feb 2013 à 01:45
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Feb 2013 à 04:46
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Feb 2013 à 04:46
look into IF function