View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nbaker nbaker is offline
external usenet poster
 
Posts: 4
Default Calculation of workdates

I have a spreadsheet that calculates a future date based upon the number of
free days allowed from a pick up date. Example: Pick up date 4/7/2009,
number of free days 14, last free date 4/20/2009. However if this date
returns a weekend date I need it to tell me the prior work date available
less any holidays. Does anyone know the formula for this?