Calculte Project Days
Posted: 16 Jun 2021, 04:40
Hi all,
is it possible to calculate the days of any project which is planned for an employee?
If it is possible, i need to devide the Report in Mo-Fr (weekdays), Sa-So (weekend days) and public holidays.
For eg:
Employee "Peter" has worked at the project "Testing Software" from the 14.06.2021 - 21.06.2021.
This means he has worked 6 weekdays (Mo-Fr + Mo) and 2 weekend days (Sa-So)
So i need a Report, maybe in Excel, with the following colums:
Name|Workdays|weekend days|public holidays
Peter |6 |2 |0
Thank you for your support!
Best greetings from germany
Patrick
is it possible to calculate the days of any project which is planned for an employee?
If it is possible, i need to devide the Report in Mo-Fr (weekdays), Sa-So (weekend days) and public holidays.
For eg:
Employee "Peter" has worked at the project "Testing Software" from the 14.06.2021 - 21.06.2021.
This means he has worked 6 weekdays (Mo-Fr + Mo) and 2 weekend days (Sa-So)
So i need a Report, maybe in Excel, with the following colums:
Name|Workdays|weekend days|public holidays
Peter |6 |2 |0
Thank you for your support!
Best greetings from germany
Patrick