[postlink]http://mastermicrosoftexcel.blogspot.com/2010/05/networkdays.html[/postlink]http://www.youtube.com/watch?v=ENy3zI5RUM0endofvid
[starttext]
To calculate the working day, Excel provides an useful function "Networkdays([start date],[end date],[holiday]). It also withdraw the holiday between the start and end date. Note that in Excel, Networkdays is from "Monday to Friday", only 5 working day. So, what to do, if some companies have working day from Monday to Saturday, 6 working day, or 7 working days.
find out next lesson,
[endtext]
[starttext]
To calculate the working day, Excel provides an useful function "Networkdays([start date],[end date],[holiday]). It also withdraw the holiday between the start and end date. Note that in Excel, Networkdays is from "Monday to Friday", only 5 working day. So, what to do, if some companies have working day from Monday to Saturday, 6 working day, or 7 working days.
find out next lesson,
[endtext]
Posts
0 comments:
Post a Comment