LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
lsmft
 
Posts: n/a
Default Business Days Only


I start new spreadsheets on Jan 1st and July 1st, then click and drag
them out row "A" to have 6 months of days to work with. Since I only
want business days, I always have to manually go back and delete all of
the Saturdays and Sundays off each sheet. Not the hardest work in the
world but since I'm lazy I'd like to know if there is a way that I can
let Excel 2000 delete them automatically. All I need is Monday thru
Friday anyway.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=520746

 
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
How many business days were in 2005? TC Excel Worksheet Functions 6 January 14th 06 08:42 PM
Circular Equation? wrap on 5 business days.. nastech Excel Discussion (Misc queries) 1 December 23rd 05 05:09 AM
With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! With this business with ONLY 5,- EUR OVER 61,370 E Charts and Charting in Excel 0 September 19th 05 02:58 AM
With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! With this business with ONLY 5,- EUR OVER 61,370 E Charts and Charting in Excel 0 September 19th 05 02:58 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 05:20 PM


All times are GMT +1. The time now is 11:02 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"