Excel 2010 - IF function with dates
Closed
Diana
-
Dec 22, 2011 at 07:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 22, 2011 at 09:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 22, 2011 at 09:50 AM
Related:
- Excel 2010 - IF function with dates
- Microsoft office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- Microsoft publisher 2010 free download - Download - Publishing
- Excel marksheet - Guide
- Number to words in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 22, 2011 at 09:50 AM
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
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
