Thread: Working Weeks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Bennett
 
Posts: n/a
Default Working Weeks

I need to calculate the number of working weeks that have accumulated at any
given date.

Obviously, TODAY()-the start date / 7 will give an approximate result, but I
really want to just count weekdays. So, Weds = 0.6, Thurs = 0.8, Fri = 1.0
but then Sat & Sun don't count.

Any ideas?