Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
1. Enter a date in A1
2. Select Row 1. Right clickFormatCellsCustom 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 --------------- Jacob Skaria "PL" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
For quarterly dates, use the following formula:
=DATE(YEAR(A1),MONTH(A1)+3,1) Regards Fred "Jacob Skaria" wrote in message ... 1. Enter a date in A1 2. Select Row 1. Right clickFormatCellsCustom 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 --------------- Jacob Skaria "PL" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Given a date, how do I get the 1st date and the last date of theprevious month? | Excel Worksheet Functions | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |