How to manually add week data

[heather]

@lava890 !

You might check out this thread and see if it helps?

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

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: https://support.google.com/docs/answer/3294949?hl=en 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…