View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MIchel Khennafi
 
Posts: n/a
Default 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