MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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