Thank you both, now a question in relation to this. I do 6 month and yearly
reviews and I only want the information to pull during that time period. How
can I formulate this to pull either the last 6 months or 12 months? Is this
possible? Thank you again!!

"Zack Barresse" wrote:

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"?