Setting up columns based on a date

  • Thread starter Thread starter MIchel Khennafi
  • Start date Start date
M

MIchel Khennafi

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
 
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
 
Back
Top