Calculating dates to include Saturdays but not Sundays

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

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
 
Back
Top