View Single Post
  #1   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

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