MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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