Adding business days to a date
Posted by Stacey S on December 12, 2001 11:48 AM
I am sure there is a simple answer to this, however I have not been able to figure it out. All I need to do is add 6 days to an existing date from another cell. I am sure someone out there uses this to figure out delivery dates or due dates..
Posted by Jacob on December 12, 2001 12:02 PM
Hi
Lets say the date is in A1 and you want the new date in A2
in A2 put =A1+6
thats all there is to it.
Just make sure that A2 is formatted as a date and you are all set.
Jacob
Posted by Aladin Akyurek on December 12, 2001 12:16 PM
Stacey --
You can use
=WORKDAY(A1,6)
where A1 houses the date to which you want to add 6 business days.
Note. You need to activate Analysis Toolpak via Tools|Add-Ins in case you get a #NAME? error in applying this formula.
Aladin
