Weeknumber formula help

I want to count all instances in a weeknumber, but the formula I'm thinking to use is not working and is returning #INVALID DATA TYPE. The 4 is the week number I am looking to count all the instances in.

The reference column is a Date format with nothing but dates in it, so I'm not sure what I am doing wrong, help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!