View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Month and Year in Excel 2003

With your first date in A1, put this in A2 and copy down.......

=TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"MMMM YYYY")

Vaya con Dios,
Chuck, CABGx3


"Howard Brazee" wrote in message
...
I'd like to have a column that displays incremental month and year (no
day).

How do I do this?