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
Automatically Insert Dates For Week Off One Day Entry 7
Calculating End Date - Given working 4, 5, 6, or 7 day workweek. 9
formatting by week number 5
Planned Open Market Days 0
Finish Date calculating incorrectly - ignoring Duration 4
7 day/24hr tasks in a 5 day work week calendar 2
how to get "EndDate" of a project? 2

Top