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

You're welcome Howard.......thanks for the feedback.......

And, BTW, you might check your System Clock......from the time of your post,
it appears to be slow.

Vaya con Dios,
Chuck, CABGx3


"Howard Brazee" wrote in message
...
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.