LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating the first day of the week jimbo New Users to Excel 5 December 30th 08 02:51 PM
6 day work week tkirchoff10 Charts and Charting in Excel 1 January 21st 07 05:13 AM
calculating a date using the day of the week as a starting point? Simon Excel Worksheet Functions 2 July 12th 06 02:32 PM
Calculating a colmun to total a 40 hour work week Harley mom Excel Worksheet Functions 3 December 20th 05 07:41 PM
Calculating total work week hours Harley mom Excel Worksheet Functions 2 December 20th 05 05:41 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"