MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Funtion to change date by two years


Posted by Sam Wactor on January 02, 2002 7:48 AM

Hi Folks,
I need a funtion that will change a date by two years. For instance. If the date 1/2/02 is entered in cell A1. I want the same date plus 730 days to appear in another cell of my choice.
Thanks, Sam


Posted by Scott on January 02, 2002 7:50 AM

Try this: =A1+730 (NT)

Posted by Aladin Akyurek on January 02, 2002 7:52 AM

Sam --

=EDATE(A1,24)

will give you what you want. You need Analysis Toolpak in order to use this function, which you can activate via Tools|Add-Ins.

Aladin

============

Posted by Sam on January 02, 2002 9:24 AM

Aladin, I have the toolpak installed, Which Analysis procedurre do I use. Any info would be helpful,
Thanks, Sam

Posted by Aladin Akyurek on January 02, 2002 9:33 AM

Check just the one which is called "Analysis ToolPak" by activating Tools|Add-Ins. Otherwise you will get a #NAME? error when using EDATE.

Aladin

=========== , I have the toolpak installed, Which Analysis procedurre do I use. Any info would be helpful,

Posted by Sam on January 02, 2002 11:18 AM

Aladin, It works perfect. Thanks a lot
Sam