View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Calculate End Date

With weekends just add the numbers

=A1+number_of_days

without weekends

=WORKDAY(A1,number_of_days,holidays)

lookup WORKDAY in help, it's part of the
ATP which comes with Excel but is not always installed


--


Regards,


Peo Sjoblom


"CrimsonPlague29" wrote in
message ...
How can I calculate the final date if I have the following(need including
weekends and without weekends)

Create Date # of Days End Date with weekends End Date with out
Weekends
01/10/08 49
01/10/08 65

Thanks