View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Babs in Ohio Babs in Ohio is offline
external usenet poster
 
Posts: 6
Default Date issue to automate calendar - So much ado about nothing

Thanks to everyone who helped! :-)
--
Babs


"Dave Thomas" wrote:

Never have I seen so much ado about nothing. hehehe

"Babs in Ohio" wrote in message
...
I have a start date of 11/1/2008 - What I want to populate is a table that
has columns for Jan-08, Feb-08, Mar-08 etc begining with January ending
with
December.

I know I can type the column headers, but I want the column headers to
display the correct year if my start date becomes 2/1/2009. Therefore
Jan-09,
Feb-09, Mar-09 etc.

Is there any formula that I can use?
--
Babs