View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Howard Brazee Howard Brazee is offline
external usenet poster
 
Posts: 68
Default Month and Year in Excel 2003

On Thu, 17 Jul 2008 17:09:26 -0700, "CLR"
wrote:

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

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


Thanks, that worked nicely.