Using Tiller's formula for week/month data results in error

Google Sheets
5

Hi @Blake,
You could use the WEEKNUM() function to create a week number column based on whatever week starting day you want. See the options here:

The formula would be something like this:

={“Week Number”;arrayformula(iferror(weeknum($B2:$B,1)))}

This assumes your Transaction dates are in column B. Also, the ,1 at the end would be for weeks starting Sunday. For weeks starting Monday, change the 1 to 2.

You might need to adjust the Week Number column format so its shows a number and not a date.

Does that work for you?

Jon