ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculating days (https://www.excelbanter.com/excel-worksheet-functions/7223-calculating-days.html)

Wildturkey9521

Calculating days
 
I need to calculate the number of days it takes for one task to be complete.
I have a begining date and an end date. Also, what about weekends? Is there
a way to substract weekends.

Thanks for your help.

Paul B

Wildturkey, have a look at NETWORKDAYS in help

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Wildturkey9521" wrote in message
...
I need to calculate the number of days it takes for one task to be

complete.
I have a begining date and an end date. Also, what about weekends? Is

there
a way to substract weekends.

Thanks for your help.





All times are GMT +1. The time now is 08:27 PM.

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