| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up columns based on a date
Good evening,
Has anyone addressed the following issue: - In A1, I have a hire date - In A5 to Z5 I want to display the 24 months based on the hire date (including present month) For instance in A1 I have 12/1/05 I would like A5 to Z5 to show Dec 05 / Jan 06 / Feb 06 / ... / Dec 07 Any help and / or direction would be welcome. Michel |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Setting up columns based on a date
One way
In A5 enter = A1 formatted as custom mmm yy In B5 enter = EDATE($A$1,COLUMNS($A5:A5)) please note the dollar signs...... extend accross to Z5 -- Greetings from New Zealand Bill K "MIchel Khennafi" wrote in message ... Good evening, Has anyone addressed the following issue: - In A1, I have a hire date - In A5 to Z5 I want to display the 24 months based on the hire date (including present month) For instance in A1 I have 12/1/05 I would like A5 to Z5 to show Dec 05 / Jan 06 / Feb 06 / ... / Dec 07 Any help and / or direction would be welcome. Michel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Function for 3 date columns | Excel Worksheet Functions | |||
| get a total based on criteria in two columns | Excel Worksheet Functions | |||
| merging columns - one date, one time | Excel Worksheet Functions | |||
| Hiding columns based on user/password | Excel Worksheet Functions | |||
Linear Mode
