Setting up columns based on a 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
 
B

Bill Kuunders

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 1
If certain date is past certain date. 3
Count based on multiple criteria 2
Changing Sum Range Based on Date Chosen from Drop Down List 1
Using a range of dates to add data in a different column? 2
Linking to other worksheets 3
When building a chart Dates are been included that are not in thedate range 1
Averaging seconds 3

Top