![]() |
Auto Fill Weekdays Only
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. . |
All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com