pianoer 's personal annotations on this page
Pianoer bookmarked
on 2008-08-02
-
11. Find total working days between any two dates, including holidays
If you work on project plans, gantt charts alot, this can be totally handy. Just type
=networkdays(start date, end date, list of holidays)to fetch the number of working days. In the above sample you can see the number of working days between New years day and September first of this year (labor day).
This link has been bookmarked by 38 people . It was first bookmarked on 01 Aug 2008, by Rafael Ribas.
-
-
Change the color of various sheet name tabs
-
-
Stephanie BuhlWho said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5
-
Mark BlairWho said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do.
-
-
11. Find total working days between any two dates, including holidays
If you work on project plans, gantt charts alot, this can be totally handy. Just type
=networkdays(start date, end date, list of holidays)to fetch the number of working days. In the above sample you can see the number of working days between New years day and September first of this year (labor day).
-
-
Rashid Al-Yahyaisite with excel tips and illustrated
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.