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 |
End Date Week Ending Date Working Days 16/09/2023 17/09/2023 5 17/09/2023 17/09/2023 5 18/09/2023 24/09/2023 5 19/09/2023 24/09/2023 5 20/09/2023 24/09/2023 5 21/09/2023 24/09/2023 5 22/09/2023 24/09/2023 5 23/09/2023 24/09/2023 5 24/09/2023 24/09/2023 5 25/09/2023 01/10/2023 5 26/09/2023 01/10/2023 5 27/09/2023 01/10/2023 5 28/09/2023 01/10/2023 5 29/09/2023 01/10/2023 5 30/09/2023 01/10/2023 5 01/10/2023 01/10/2023 5 02/10/2023 08/10/2023 5 03/10/2023 08/10/2023 5 04/10/2023 08/10/2023 5 05/10/2023 08/10/2023 5 06/10/2023 08/10/2023 5 07/10/2023 08/10/2023 5 08/10/2023 08/10/2023 5 09/10/2023 15/10/2023 5 10/10/2023 15/10/2023 5 11/10/2023 15/10/2023 5 12/10/2023 15/10/2023 5 13/10/2023 15/10/2023 5 14/10/2023 15/10/2023 5 15/10/2023 15/10/2023 5 16/10/2023 22/10/2023 5 17/10/2023 22/10/2023 5 18/10/2023 22/10/2023 5 19/10/2023 22/10/2023 5 20/10/2023 22/10/2023 5 21/10/2023 22/10/2023 5 22/10/2023 22/10/2023 5 23/10/2023 29/10/2023 5 24/10/2023 29/10/2023 5 25/10/2023 29/10/2023 5 26/10/2023 29/10/2023 5 27/10/2023 29/10/2023 5 28/10/2023 29/10/2023 5 29/10/2023 29/10/2023 5 30/10/2023 05/11/2023 5 31/10/2023 05/11/2023 5 01/11/2023 05/11/2023 5 02/11/2023 05/11/2023 5 03/11/2023 05/11/2023 5 04/11/2023 05/11/2023 5 05/11/2023 05/11/2023 5 06/11/2023 12/11/2023 5 07/11/2023 12/11/2023 5 08/11/2023 12/11/2023 5 09/11/2023 12/11/2023 5 10/11/2023 12/11/2023 5 11/11/2023 12/11/2023 5 12/11/2023 12/11/2023 5 13/11/2023 19/11/2023 5 14/11/2023 19/11/2023 5 15/11/2023 19/11/2023 5 16/11/2023 19/11/2023 5 17/11/2023 19/11/2023 5 18/11/2023 19/11/2023 5 19/11/2023 19/11/2023 5 20/11/2023 26/11/2023 5 21/11/2023 26/11/2023 5 22/11/2023 26/11/2023 5 23/11/2023 26/11/2023 5 24/11/2023 26/11/2023 5 25/11/2023 26/11/2023 5 26/11/2023 26/11/2023 5 27/11/2023 03/12/2023 5 28/11/2023 03/12/2023 5 29/11/2023 03/12/2023 5 30/11/2023 03/12/2023 5 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 🙂