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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!