Hi all,
I’m doing a cumulative $ sales by week ticket widget, and I was wondering- is there a way to have “week ending dt” for my rows instead of week number and year? For example, rows of week ending 2/13, 2/20, 2/27 etc, instead of 7 2022, 8 2022, 9 2022? I’m not doing any year on year comparison at this point, just a simple running total (trying to wean some people off of an excel spreadsheet). My brain isn’t working right, and I can’t remember if this is not possible, or if I just don’t remember how to do it, lol!
Thanks,
Kathleen
Not sure about week ending, but I do week beginning using the Weeks and then a custom format dd, MMM to give me 01, Feb formatted dates :)
Not sure how you would do week ending though unfortunately, hopefully someone else can help!
So my running table looks like this:
This is great! Thanks for sharing.
this is 100% what I needed (can absolutely make week beginning work)! Thanks for getting me over my mind block! :-)