Figuring Dates quit working!
 

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?

Figuring Dates quit working!
 

Sounds like your file has moved.

Just try

=EOMONTH(E15,B15-1)

--

HTH

Bob

"rroswell86" wrote in message
...
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?

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?