Forum Discussion
If date between project date ranges return value, if outside date range return ZERO
Hi, I am currently desiging a project report and have a problem getting the right figures in each column for weekly figures For Example, this is how the data is stored Peter Smith (Proje...
BADGER has 22 working days, not 21.
| PROJECT | NAME | Start Date | End Date | Hours Assigned | Working Days in Period | Hrs Per Day |
| KANGAROO | Peter Smith | 16//09/2023 | 31/10/2023 | 50 | 32 | 1.563 |
| BADGER | John Doe | 01/10/2023 | 31/10/2023 | 22 | 21 | 1.048 |
| LION | Jane Taylor | 01/10/2023 | 07/10/2023 | 40 | 5 | 8.000 |
| TIGER | Lou Reed | 01/11/2023 | 30/11/2023 | 176 | 22 | 8.000 |
Base Data
- lbendlin
Super User
Thank you for the sample data. Next you need to indicate what you mean by 5 working days. For example 2023-09-16 was a saturday. Is that considered to be a working day? or should it be ignored? Do you want to consider holidays?
Working Days are Monday to Friday only.. thanks 🙂
- lbendlin
BADGER has 22 working days, not 21.