Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How many business days were in 2005? | Excel Worksheet Functions | |||
Circular Equation? wrap on 5 business days.. | Excel Discussion (Misc queries) | |||
With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! | Charts and Charting in Excel | |||
With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! | Charts and Charting in Excel | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) |