Thread: Start Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Start Date

OK, if you have the Analysis Toolpack add-in loaded,

=end date-workday(end date,number of workdays,holiday dates)

"Daviv" wrote:

Is there a function that calculates the start date given the contract
duration and completion date while excluding the holidays? Similar to
workdays but reverse.
--
Thanks!