Google sheet is a good tool to work with your team; share the data and collaborate each other.
One of the function in google sheet is Networkdays function used to calculate the number of working days between two dates i.e. start date and end date.
If you have list of closed holidays; feed the dates and incorporate in the formula to reduce the holidays from the working days.
Sheet will calculate / count all working days between Monday to Friday and reducing the holidays given by us.
The function will help us to work for the project on a focus manner; since it is in google sheet all the team members can record the progress in the sheet to complete it in time.
Example: Refer the google sheet to under the function with an example / sample data
https://docs.google.com/spreadsheets/d/1DCv8e25kIzQFwV_5_6yL24RueE-lkjpcGoa9GVr0nD8/edit?usp=sharing
One of the function in google sheet is Networkdays function used to calculate the number of working days between two dates i.e. start date and end date.
If you have list of closed holidays; feed the dates and incorporate in the formula to reduce the holidays from the working days.
Sheet will calculate / count all working days between Monday to Friday and reducing the holidays given by us.
The function will help us to work for the project on a focus manner; since it is in google sheet all the team members can record the progress in the sheet to complete it in time.
Example: Refer the google sheet to under the function with an example / sample data
https://docs.google.com/spreadsheets/d/1DCv8e25kIzQFwV_5_6yL24RueE-lkjpcGoa9GVr0nD8/edit?usp=sharing
No comments:
Post a Comment