James Perry
Member
Hi all....
Looking4 a formula to determine month or year in a range of cells.
A B C D E F G H I
1 SUN MON TUE WED THU FRI SAT YEAR MONTH
2 03/28/10 03/29/10 03/30/10 03/31/10 04/01/10 04/02/10 04/03/10 2010 MAR
The desired result in cell H2 displays the YEAR in which the values (dates) in range A2:G2 occur.
What formula may be used to accomplish the same?
The desired result in cell I2 displays the MONTH in which the values (dates) in range A2:G2 occur.
What formula may be used to display the month in which the values (dates) in cell range A2:G2 occur?
Note - I've shown the desired result in cells H2 & I2 (above) manually, but i wish to have a formula that would produce the same results.
Thank You.
Looking4 a formula to determine month or year in a range of cells.
A B C D E F G H I
1 SUN MON TUE WED THU FRI SAT YEAR MONTH
2 03/28/10 03/29/10 03/30/10 03/31/10 04/01/10 04/02/10 04/03/10 2010 MAR
The desired result in cell H2 displays the YEAR in which the values (dates) in range A2:G2 occur.
What formula may be used to accomplish the same?
The desired result in cell I2 displays the MONTH in which the values (dates) in range A2:G2 occur.
What formula may be used to display the month in which the values (dates) in cell range A2:G2 occur?
Note - I've shown the desired result in cells H2 & I2 (above) manually, but i wish to have a formula that would produce the same results.
Thank You.
