Notifications
Clear all
Power Query
4
Posts
2
Users
0
Reactions
54
Views
Topic starter
Greetings. Help me with a formula to identify the number of particular days of a month. For example, how many Mondays, Tuesdays, etc are in March? It could be done so that it runs through all the months of the year. Thank you
Thank you
Posted : 20/03/2024 7:08 pm
Any reason why you must do this in PQ? Otherwise it's quite easy in Excel with a list dates and a pivot table. See attached example that has dates for the first quarter of 2024.
Posted : 21/03/2024 11:49 am
Topic starter
Thank you Riny Van, but I didn't get to see the attachment you did mention
Posted : 21/03/2024 3:50 pm
Oops, I did it again!
Here it is.
Posted : 22/03/2024 1:32 am
