Put 1/1/05 into A1, then put this in A2: =DATE(YEAR(A1), MONTH(A1)+1,
DAY(A1))
************
Anne Troy
www.OfficeArticles.com

"BorisS" wrote in message
...
I'd like to figure out a clever way to build a dynamic date heading row.
I
need to enter the first month (1st of the month) and have the following
columns all be the 1st of the subsequent month. I know I can just add
31,
but that does't get me precisely to the 1st each time. I know I can do
date() using the previous column's data and adding 1 to month, but then I
have to IF for the case that I am hopping from December to Jan. Any other
way that is a function I don't know about?
--
Boris