Last week I have received a mail from my team members stating that he was wasting his time to find the working days between two days to calculate the mandays calculations for the project.
I have given the below suggtions to make his job easier
Excel has a date function called NETWORKDAYS; which is a function to find out the working day i.e. Monday to Friday in between two given dates.
For example;
Let us assume - Project start date : 25 Oct 2013
Project completion date : 31 Jan 2014
and the following are the closed holidays - 5 & 6 Nov; 25 Dec; 1, 14,15,26 Jan
The simple formula would be {=NETWORKDAYS(Startdate, enddate, [holidays])}
I have given the below suggtions to make his job easier
Excel has a date function called NETWORKDAYS; which is a function to find out the working day i.e. Monday to Friday in between two given dates.
For example;
Let us assume - Project start date : 25 Oct 2013
Project completion date : 31 Jan 2014
and the following are the closed holidays - 5 & 6 Nov; 25 Dec; 1, 14,15,26 Jan
The simple formula would be {=NETWORKDAYS(Startdate, enddate, [holidays])}
The formula will give you the result 65 working days.
There are 71 weekdays in that 6 closed holidays given in the range. Hence the result is 65 working days.
The same formula may be applied to set of records in the excel database; it eliminates the cumbersome calculations and formulas for the recquired result.
No comments:
Post a Comment