Get Sequence of Months parallel to sequence of number.
In previous blog :
For sequence of number we used MOD function.
C4 =MOD(C3,12)+1
For, Sequence Month:
Formula: =TEXT(DATE(2000,C4,1),"mmm") in E4 cell.
Drag down the formula, you will get Months in series.
From Jan to Dec , then start jan to Dec and so on.
In previous blog :
For sequence of number we used MOD function.
C4 =MOD(C3,12)+1
For, Sequence Month:Formula: =TEXT(DATE(2000,C4,1),"mmm") in E4 cell.
Drag down the formula, you will get Months in series.
From Jan to Dec , then start jan to Dec and so on.
No comments:
Post a Comment