View Single Post
  #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