Thread
:
Month and Year in Excel 2003
View Single Post
#
4
Posted to microsoft.public.excel.programming
Howard Brazee
external usenet poster
Posts: 68
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.
Reply With Quote
Howard Brazee
View Public Profile
Find all posts by Howard Brazee