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
