Excel : Week number of the month calculation | Tableau Tip

preview_player
Показать описание
How to calculate WEEK OF MONTH in the excel?
a=get week of year using WEEKNUM function
b=get start date of each month and find WEEKNUM
a-b+1 is the required output
2-1-2018 -week of year is 5, week of the month is 1.

#excel
Рекомендации по теме
Комментарии
Автор

Bro, content is so good, pls add voice

sowjiyadhav