|
| 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
October 22nd, 2004, 12:39 PM
|
|||
|
|||
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
October 22nd, 2004, 03:54 PM
|
|||
|
|||
|
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
October 22nd, 2004, 05:13 PM
|
|||
|
|||
|
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 |
Linear Mode
