Year to date Prior Year formula

Ask a Question

Hiya,

I'm well aware that this has been asked many many times, however when searching for the answer I can't find an answer that is working for me.

I have full 2018 data and need to do 2018 YTD but to prior month.

My data is loaded in on the 1st of the month for the prior month. So at the moment the data goes up to August 2019.

I need to be able to compare this to August 2018 without selecting the months and have it automatically roll forward each month.

Currently the formulas I've found and have been trying are:

I can't get any of them to work for my app.

Please could someone help and let me know where I'm going wrong?

I don't want to create a master calendar in the script if possible.

Thanks!!!

Megan

0 Replies