Dates
 

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.

Hi

With specified date in A1
=DATE(YEAR(A1),MONTH(A1)+7,1)


Arvi Laanemets


"aeroman55" wrote in 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.

=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.
.