Forum Discussion
Working days and holidays
Hello Community,
I have a question about wokring days.
Before you send me links here, i read it and thats why i post this question.
I read the page of Alberto Ferrari : http://sqlblog.com/blogs/alberto_ferrari/archive/2011/01/19/working-days-computation-in-powerpivot.aspx
After that, I create a calendar and an another table with all holidays here :
| Jour Férié (France) | Annee | Jour semaine | Jour | DateComplète | Mois | Date |
| Jour de l'an | 2018 | 0 | Lundi | lundi 1 janvier 2018 | Janvier | 1 janvier 2018 |
| Pâques | 2018 | 6 | Dimanche | dimanche 12 avril 2020 | Avril | 12 avril 2020 |
| Lundi de Pâques | 2018 | 0 | Lundi | lundi 13 avril 2020 | Avril | 13 avril 2020 |
| Fête du Travail | 2018 | 1 | Vendredi | vendredi 1 mai 2020 | Mai | 1 mai 2020 |
| Armistice 1945 | 2018 | 1 | Vendredi | vendredi 8 mai 2020 | Mai | 8 mai 2020 |
I make realtion between my calendar and my holidays table, and its working.
I begin with the Excel Working Days : and it doesnt works .
IF (OR ([@WeekDay] = 6, [@WeekDay] = 7), 0, IF (ISNA (VLOOKUP ([@Date], HolidaysTable[#Data], 2, FALSE)), 1, 0))
The first part is working : IF (OR ([@WeekDay] = 6, [@WeekDay] = 7), 0, 1) I have the good result. But how can i check in my jours fériés table if the date are present and if its the case then it's not a working days.
Thank you in advance
1 Reply
- v-chuncz-msft
Community Support