Date Problem's

[bperks]

I am trying to figure out how to take a date (01/01/05) in A1, and
months in A2 (the months could vary from 12 all the way up to 60)and
have A3 show me the actual date format of 01/01/05 + 60 months =
01/01/10 or whatever it would be due to the leap years and all. Thanks
in advance for any help!!!!

Effective Date (A1) 01/01/05
Term in Months (A2) 60
Expiration Date (A3) ________

[Paul Sheppard]

I am trying to figure out how to take a date (01/01/05) in A1, and
months in A2 (the months could vary from 12 all the way up to 60)and
have A3 show me the actual date format of 01/01/05 + 60 months =
01/01/10 or whatever it would be due to the leap years and all. Thanks
in advance for any help!!!!

Effective Date (A1) 01/01/05
Term in Months (A2) 60
Expiration Date (A3) ________

Hi bperks

Try this

In A3 enter =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))

[FSt1]

hi,
in cell A3 put this....
=EOMONTH(A1,A2)
then format to date.
for your example the results would be 1/31/05.

regards
FSt1
"bperks" wrote:

> I am trying to figure out how to take a date (01/01/05) in A1, and
> months in A2 (the months could vary from 12 all the way up to 60)and
> have A3 show me the actual date format of 01/01/05 + 60 months =
> 01/01/10 or whatever it would be due to the leap years and all. Thanks
> in advance for any help!!!!
>
> Effective Date (A1) 01/01/05
> Term in Months (A2) 60
> Expiration Date (A3) ________
>
>

[Bob Phillips]

=date(year(a1),month(A1)+A2,day(A1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bperks" <[email protected]> wrote in message
news:[email protected]...
> I am trying to figure out how to take a date (01/01/05) in A1, and
> months in A2 (the months could vary from 12 all the way up to 60)and
> have A3 show me the actual date format of 01/01/05 + 60 months =
> 01/01/10 or whatever it would be due to the leap years and all. Thanks
> in advance for any help!!!!
>
> Effective Date (A1) 01/01/05
> Term in Months (A2) 60
> Expiration Date (A3) ________
>

[Ron Rosenfeld]

On 30 Aug 2005 09:50:10 -0700, "bperks" <[email protected]> wrote:

>I am trying to figure out how to take a date (01/01/05) in A1, and
>months in A2 (the months could vary from 12 all the way up to 60)and
>have A3 show me the actual date format of 01/01/05 + 60 months =
>01/01/10 or whatever it would be due to the leap years and all. Thanks
>in advance for any help!!!!
>
>Effective Date (A1) 01/01/05
>Term in Months (A2) 60
>Expiration Date (A3) ________

=EDATE(A1,A2)

Format as date.

If the EDATE function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.



--ron

[Ron Rosenfeld]

On Tue, 30 Aug 2005 12:34:29 -0500, Paul Sheppard
<[email protected]> wrote:

>
>bperks Wrote:
>> I am trying to figure out how to take a date (01/01/05) in A1, and
>> months in A2 (the months could vary from 12 all the way up to 60)and
>> have A3 show me the actual date format of 01/01/05 + 60 months =
>> 01/01/10 or whatever it would be due to the leap years and all.
>> Thanks
>> in advance for any help!!!!
>>
>> Effective Date (A1) 01/01/05
>> Term in Months (A2) 60
>> Expiration Date (A3) ________
>
>Hi bperks
>
>Try this
>
>In A3 enter =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))

May be a problem if the DAY in A1 does not exist in the resultant month.

e.g. 49 months after 31 Jan 2005 --> 3 Mar 2009.

The OP might prefer 28 Feb 2009.


--ron

[Ron Rosenfeld]

On 30 Aug 2005 09:50:10 -0700, "bperks" <[email protected]> wrote:

>I am trying to figure out how to take a date (01/01/05) in A1, and
>months in A2 (the months could vary from 12 all the way up to 60)and
>have A3 show me the actual date format of 01/01/05 + 60 months =
>01/01/10 or whatever it would be due to the leap years and all. Thanks
>in advance for any help!!!!
>
>Effective Date (A1) 01/01/05
>Term in Months (A2) 60
>Expiration Date (A3) ________

In addition to my previous post, if you do not have/want the analysis tool
pack, an equivalent formula would be:

=IF(MONTH(DATE(YEAR(A1),MONTH(A1)+B1,
DAY(A1)))<>MONTH(A1),DATE(YEAR(A1),
MONTH(A1)+B1,DAY(A1))-DAY(DATE(YEAR(
A1),MONTH(A1)+B1,DAY(A1))),DATE(YEAR(
A1),MONTH(A1)+B1,DAY(A1)))

Both this and the EDATE formula assume that One month after January 31 would be
February 28, and not Mar 2 or Mar 3. In other words, they adjust for the
unequal numbers of days in months.


--ron