Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
use WORKDAY for this. e.g. =WORKDAY(A1,10) Note: the Analysis Toolpak Addin has to be installed for this -----Original Message----- Hey, I'm new with excess and trying to use it to estimate the days between stages at a construction site. For example, Starting Date of Excavation is 6/2/04...I need it to calculate 10 days from that date and not land on a weekend. If 10 days did land on a weekend then it would just get bumped to the monday. Please help if you can. Thank you. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill series by weekdays in XL 2007 | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
using auto fill edit or fill handel | Excel Worksheet Functions | |||
Fill dates with weekdays/workdays only | Excel Worksheet Functions | |||
auto filter and auto fill | Excel Programming |