LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Proj mgr
 
Posts: n/a
Default How do I set up a calculation to exclude weekends?

Hello,
I am using Excel to schedule construction processes for homes. It is set up
by columns. Example "Column B..Row 2" gets the actual date typed in and I
set up calculations to add days to the schedule. For instance: Column B..Row
3 would be Row 2 +1. I want to have Saturday and Sunday automatically add
2 days to the calculation. I would need the new dates to carry forward. Is
this possible?

 
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
Date Calculation to exclude weekends Vim Excel Worksheet Functions 2 January 24th 06 02:58 PM
Use networkdays INCLUDE weekends, Exclude holidays ronnomad Excel Worksheet Functions 4 December 16th 05 04:55 PM
Exclude non-numeric data from calculation jostermi Excel Worksheet Functions 1 August 23rd 05 07:54 PM
calculation to exclude weekends Need2Know Excel Worksheet Functions 6 July 14th 05 09:01 PM
Schedule to exclude weekends and holidays Erin D. Excel Discussion (Misc queries) 3 March 15th 05 09:49 PM


All times are GMT +1. The time now is 08:58 AM.

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"