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
|