ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Fill Weekdays Only (https://www.excelbanter.com/excel-programming/301622-auto-fill-weekdays-only.html)

Frank Kabel

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