Week number of a date in a month
I have a column that has a list of dates. I tried the WEEKNUMBER function, and it returned a number reflecting the week of the year, 1-53, but I am looking for a formula that will return a number corresponding with the week the date falls in. For example, 10/11/2022 is in the third week of October, so it should return a value of 3. Thanks!
Help Article Resources
Check out the Formula Handbook template!