Year to Date Function

John Amador

I'm trying to set up a formula to where I can calculate Year to Date metrics from last year but up until present day. Example if today is May 1st I want to compare Jan-May 1st 2019 to Jan-May 1st 2020, I can do this if it fixed but what I want to accomplish is it to run automatic like Today() function that is continuously going on based on today's date.

Genevieve P.

Hi John,

Would you be able to provide us with a bit more detail? It would be helpful to see screen captures of your sheet(s) (but block out any sensitive data) with a description of the type of metrics you are looking to collect.

If you already have a formula built that's working but in a static way, it would be useful to see that, too!

You can use the TODAY function but specify "in the past number of days from Today"... so for example TODAY(-365) is 365 days ago. Therefore, you could say in a formula, look >= TODAY(-365) and also look <=TODAY() to have it calculate between these two dates.

Cheers!

Genevieve