Page 1 of 1

Calculte Project Days

Posted: 16 Jun 2021, 04:40
by pg1848
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