I would like to compare the data of this year YTD (the data of this month is only available the month afterwards) with the data of previous year and therefore exclude the data of October in 2019. However I don't have dates, I just have numbers for the month. For example 1 is January and so on.
Is it possible to use an automatic formula which excludes October this month, which will exclude November next month and so on ?
Hello. In advance, if i wrote something wrong, sorry for my english 😅.
If i understand correctly, u want to compare data from year 2019 excepto October but, do you need the 2019 complete? I mean, Do you include November and December in 2019?
For year 2020 you need compare the previous data verses Jan to Sept 2020.
Thank you for your answer 🙂 No problem for your english. Actually I have the following data : 01/01/2019 until 31/12/2019 and 01/01/2020 until 30/09/2020. I would like to compare the same period, therefore I need to compare month 1 until 9. I don't have the date, I just have the month number, that's the biggest issue
