![]() |
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 |
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