Calculating tasks using a six day work week

S

Steve22055

What kind of formula can I use to calculate when multiple tasks will complete
and using a six day work week that includes Saturday but excludes Sundays.

If a1=03/25/09 and A2 is A1+9, I want it to return the date of 04/04/09 as
the result in A2.

Your help is appreciated!
 
J

Jacob Skaria

A1 = Start Date
A2 = End Date
This formula will give you the working days

=(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*6-MIN(6,
WEEKDAY(A1,2))+MIN(6,WEEKDAY(A2,2))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does networkdays have a six day week? 1
Formula for finding Date difference between 2 dates 4
day of the week and date formula 2
Calculating End Date - Given working 4, 5, 6, or 7 day workweek. 5
how do I write a 6 day schedule? 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
4 Day Work Week in a formula 1
Calculating Time 3

Top