Sorting out past data in a prep sheet and would like to get the month and week data filled in. I’ve tried to use the formulas here:
But I keep getting a #REF! error:
“Result was not automatically expanded, please insert more rows”
I made sure it’s referring to column A but still nothing. Worth noting that I have about 500 blank rows below the data, and even then I tried inserting a few more rows to no avail.