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
|
|||
|
|||
update month itervals automatically
If say something was done in May-04 and it's not due again for another 15
monthes how do I get excel to due the math and then when it get's done in 15 monthes exel will do the math when I put the date in |
#2
|
|||
|
|||
4/05/2004
15 4/08/2005 you could use EDATE a1 = start date a2 = months a3 = =EDATE(A1,A2) SEE NOTES ON EDATE BELOW If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. R Pete -- (][ This Email has been scanned by Norton AntiVirus. ][) "Odart" wrote in message ... If say something was done in May-04 and it's not due again for another 15 monthes how do I get excel to due the math and then when it get's done in 15 monthes exel will do the math when I put the date in |
#3
|
|||
|
|||
One possible way
="Due in "&TEXT(DATE(YEAR(A1),MONTH(A1)+15,DAY(A1)),"mm/dd/yyyy") Regards, Peo Sjoblom "Odart" wrote in message ... If say something was done in May-04 and it's not due again for another 15 monthes how do I get excel to due the math and then when it get's done in 15 monthes exel will do the math when I put the date in |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatically Update a Field in Table | CK | Using Forms | 4 | September 28th, 2004 10:32 PM |
Linked table update Automatically | Les | Database Design | 1 | April 29th, 2004 03:53 AM |