Need help with date formulas

Posted by MATT-aTm on March 22, 2001 8:43 PM

I am working on an assignment and need some help creating a date formula. I am creating a loan and interest worksheet, and need to have a formula that can increase the date by 1 month with every payment. If anyone can help it will be greatly appreciated. Thanks

Matt
Fightin' Texas Aggie Class of '02

Posted by Dave Hawley on March 22, 2001 9:45 PM

Hi Matt

You could use excel EDATE for this. If your date is in cell A1 use:

=EDATE(A1,1)

EDATE is an Add-in, so you may need to go to Tools>Add-ins-"Analysis Toolpak"

Dave

OzGrid Business Applications

Posted by Aladin Akyurek on March 22, 2001 9:50 PM

Use the EDATE function.
The syntax is =EDATE(a-date,months), where months=1 in your case.
You need to add in the Analysis Toolpak via Tools|Adds in in order to activate this function.

Aladin

Posted by MATT-aTm on March 23, 2001 5:44 AM

Thanks for the help, it is greatly appreciated.

Matt
Fightin' Texas Aggie Class of '02

Posted by MATT-aTm on March 23, 2001 5:46 AM

Thanks for the help, it is greatly appreciated.

Matt
Fightin' Texas Aggie Class of '02