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
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
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
Related:
- Excel 2010 - IF function with dates
- Microsoft office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- Excel mod apk for pc - Download - Spreadsheets
- Microsoft publisher 2010 free download - Download - Publishing
- 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