Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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..

Check out our Excel Resources

Re: Adding business days to a date

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


Re: Adding business days to a date

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.