View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rebecca[_5_] Rebecca[_5_] is offline
external usenet poster
 
Posts: 2
Default Calculating dates to include Saturdays but not Sundays

I am trying to help a co-worker create a formula to count business days for
the mortgage department.

They need to be able calculate the date three days from a given date. The
three days should include Saturdays but not any federal holidays (US) or
Sundays.

They also need to do a second calculation of 7 days from a given date that
does include holidays and Saturdays. The 7 day calculation does not need to
include Sundays.

Is there any way this can be done?

Rebecca