|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 11th, 2005, 05:59 PM
|
|||
|
|||
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
January 11th, 2005, 06:21 PM
|
|||
|
|||
|
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
January 11th, 2005, 06:26 PM
|
|||
|
|||
|
=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. .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| converting dates into numbers | kikilein | General Discussion | 2 | October 20th, 2004 07:33 PM |
| Change Start Dates without Changing Due Dates | Beth | General Discussion | 0 | August 19th, 2004 03:44 PM |
| Sumproduct search between Dates | Robert Christie | Worksheet Functions | 5 | May 22nd, 2004 03:09 PM |
| Charting woes with hidden dates | dustin pockets | Charts and Charting | 4 | April 15th, 2004 04:20 AM |
| subtracting dates to give a whole number | Lasitter | Worksheet Functions | 2 | October 1st, 2003 09:14 AM |
Linear Mode
