This would be a tricky formula to create, but my guess is that you would need to create a formula that subtracts the week number of April 1st (in the year of the actual date) from the week number of the actual date.
In other words: “the week number of the actual date - the week number of April 1st of that same year.”
Then, if your result is either 0 or a positive number, you would add 1 to the result to get your week number.
If your result is a negative number, you would add 1 to the result, and then add either 52 or 53 to it, depending on how many weeks are in that current year.
I’m not exactly sure how to structure this formula — perhaps someone else can chime in.
And maybe there’s an easier way to do this, too, that I’m not aware of! :slightly_smiling_face: