ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate End Date (https://www.excelbanter.com/excel-discussion-misc-queries/173317-calculate-end-date.html)

CrimsonPlague29

Calculate End Date
 
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

Peo Sjoblom

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





All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com