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.