Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing of columns for different days of month | Excel Discussion (Misc queries) | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |