View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default How do I calculate future date after number of days

With start in A1:

=A1+21

Regards,
Per

"Vincent" skrev i meddelelsen
...
How do I calculate a future date based on the start date plus 21 days
which
must include saturdays, sundays and holidays. The function "workday"
excludes
all these days.