Excel 2010 - IF function with dates [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I am trying to show in cell J2 if the date of cell I2 is between 1/1/2011 (MM/DD/YYYY) and 12/31/2011 to show SS12 and if not between those date to show blank. Any ideas would be very helpfull.

Diana

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Diana,

So basicly you would like to know if the date in I2 contains the year 2011.

J2: =IF(YEAR(I2)=2011,SS12,"")

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!