Date

[PL]

I want to use the number format mmm-yy

For a row I want


Jan- 1998 Apr-1998 Jul-1998 Oct-1998 Jan-1999 Apr-1999 ......

In other words, I want to repeat the same months for every year, how do I do
so without doing for each cell indiviually?

Thanks

 

[Jacob Skaria]

1. Enter a date in A1
2. Select Row 1. Right click>FormatCells>Custom mmm-yy
3. In B1 enter the below formula and copy that to the cells right...
=DATE(YEAR(A1)+1,MONTH(A1),1)


If this post helps click Yes

 

[Fred Smith]

For quarterly dates, use the following formula:
=DATE(YEAR(A1),MONTH(A1)+3,1)

Regards
Fred