Is there a formula to get a specific date for the end of the year?

zdlee_*66937 · October 2021

I would like to use Dec of the following year as a lookup (example: this year is 2021, I would like to lookup revenue for Dec 2022). Is there a formula I can use to get the end of the calendar year month for the following year?

Akhtar.shahbaz · October 2021

Hi @zdlee ,

There is a different way to achieve this, you can try the below formula

Is there a formula to get a specific date for the end of the year?

Answers

Categories