I'm trying to fix an issue with my daily sales calculation.
Currently, I calculate daily sales with this formula: Sum({<Date={"$(=DATE(TODAY()-1))"}} SALE)
I treat the previous day as today's sales, so I subtract 1 day and compare it with the same date last year.
However, this year (which is a leap year) has 29 days in February instead of 28, which is causing issues when comparing sales with last year. For example, this year, February 23rd falls on a Monday, but last year, February 23rd was a Saturday, so the comparison becomes inaccurate. In this case, I would need to subtract 2 days instead of 1.
Do you have any ideas on how I can fix this issue?
because i already have this in too many sheets and apps i need weeks to fix this
