Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
=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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |