Calculate week of the month

Showcase Tips and Hacks
1

Was asked recently if it was easy to calculate the week of the month and this is how I do it -

Screen%20Recording%202018-09-07%20at%2004.55%20PM.gif915×400 1.36 MB

Here are the formulas I used. ( feel free to hide the first day of month column)

First Day of Month = ((MyDate- MyDate.Day()) + 1)
Week of Month = MyDate.WeekNumber() -[First Day of Month].WeekNumber()+1

4 Likes
2

Great stuff here.

My team works in two-week sprints.

I wonder if there’s a way to automagically add a row to a Sprint (example sprint name = “Sprint 1/2” … Which would be for the sprint that occurs during the first and second week of the year)

I’m trying “not” to have to create a table with 52 week rows and 26 sprint name rows. Hmmmm… Any help would be clutch! :bar_chart:

1 Like