=DATE(YEAR(A1),MONTH(A1)+7,1)
HTH
Jason
Atlanta, GA
-----Original Message-----
How can I return a date, six months plus the first of
the following month
from a specified date? In other words, both January 1,
2005 and January 31,
2005 would return August 1 2005.
.
|