Calculating Working Days - Department of Pathology

A

Andrea

I am putting together an autopsy tracking form for my department. The form
contains the date of autopsy. If it's a 30 (or 60 day) day autopsy, I need a
formula to figure out 30 working days from the initial date of autopsy.
Please help. Thanks!
 
B

Biff

Hi!

This method requires that the Analysis ToolPak add-in be installed.

A1 = initial date of autopsy

=WORKDAY(A1,30,HOLIDAYS)

Format the cell as DATE

Replace 30 with whatever duration you want.

Holidays are a list of holidays that you want to be included in the
calculation. Normally, you would make a list of the holidays in a separate
range.

B1 = 9/5/2005
B2 = 11/24/2005
B3 = 12/24/2005
B4 = 12/25/2005

=WORKDAY(A1,30,B1:B4)

Biff
 
Top