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

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