Excel 2010 - IF function with dates

Closed
Diana - Dec 22, 2011 at 07:53 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Dec 22, 2011 at 09:50 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Dec 22, 2011 at 09:50 AM
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
0