LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Biff
 
Posts: n/a
Default

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

"Andrea" <Andrea @discussions.microsoft.com wrote in message
...
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!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
Working time and days Nortos Excel Worksheet Functions 5 May 6th 05 04:17 PM
Working time and days Nortos Excel Discussion (Misc queries) 1 May 6th 05 03:47 PM
Calculating Working Days will Excel Worksheet Functions 5 March 22nd 05 12:44 PM
Help! I am stuck calculating Days, Hours, Mins please help OB1 Excel Worksheet Functions 3 November 15th 04 05:17 PM


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"