Prev: Absoute Cell Ref Changes When Inserting New Row in Referenced
Next: How do I compare two columns contents for differences
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" <rroswell86(a)discussions.microsoft.com> 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?
 | 
Pages: 1
Prev: Absoute Cell Ref Changes When Inserting New Row in Referenced
Next: How do I compare two columns contents for differences