| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figuring Dates quit working!
B1: Start date
A1: number of months =EDATE(B1,A1)-1 "rroswell86" wrote: I have used a spreadsheet for years (not created by me) that figures dates for leases. I enter the starting date at the top, then in a column the number of months for each step of the lease. The formula would then figure out starting and ending date for each period. Example: Starting Date 4/1/2010 3 4/1/10 6/30/10 12 7/1/10 6/30/11 The formula that suddenly quit working is copied and pasted below. ='C:\Program Files\MSO\OFFICE11\LIBRARY\Analysis\ATPVBAEN.XLA'! EOMONTH(E15,B15-1) Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| functions quit working | Excel Worksheet Functions | |||
| Hyperlinks quit working | Excel Discussion (Misc queries) | |||
| control+arrow key quit working | Excel Discussion (Misc queries) | |||
| my excel formulas have quit working | Excel Worksheet Functions | |||
| calculations quit working | Excel Discussion (Misc queries) | |||
Threaded Mode
