Thread: Remove weekends
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhhince[_2_] rhhince[_2_] is offline
external usenet poster
 
Posts: 48
Default Remove weekends

I have 2 dates and time:
5/21/2010 11:34 is in A2
5/25/2010 11:34 is in A3

If I subtract them, I get 4 days in cell A4.
I would like to subtract the weekends and give me a total of 2 days.

I came across this before, but forgot how to do it. Any help! Thanks.