| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating tasks using a six day work week
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating tasks using a six day work week
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 --------------- Jacob Skaria "Steve22055" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating the first day of the week | New Users to Excel | |||
| 6 day work week | Charts and Charting in Excel | |||
| calculating a date using the day of the week as a starting point? | Excel Worksheet Functions | |||
| Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
| Calculating total work week hours | Excel Worksheet Functions | |||
Linear Mode
