Hello Roger,

The only problem with that is the "June" is textual and not numerical, thus
erroring out when used with the YEAR or MONTH function (they look for
numerical values). You'll receive the infamous #VALUE! error for text in a
numerical equation.

--
Regards,
Zack Barresse, aka firefytr


"Roger Govier" wrote in message
...
Hi Todd
One way
=DATE(YEAR(A1),MONTH(A1)+1,1)
where 01/06/2005 is in A1

--
Regards

Roger Govier


"Todd Nelson" wrote in message
...
Is there a formula that would read the previous cell and insert the
following
month? Ex. Prev Cell is "June" the next cell would read "July"?