From: rroswell86 on 1 Apr 2010 15:17 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? From: Bob Phillips on 1 Apr 2010 15:27 Sounds like your file has moved. Just try =EOMONTH(E15,B15-1) -- HTH Bob "rroswell86" wrote in message news:00E4F127-BBDE-44E1-AEEA-AF98CF36ACF8(a)microsoft.com...>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? From: Teethless mama on 1 Apr 2010 17:24 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?