I do something very similar to this. Put the equation in the month to data column of Today + Previous day, then every day copy this equation back into previous day as VALUES only!!
and clear down your Today column ready to start again.
I do this through a very easy Macro so, which ever way takes your fancy it will work
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.