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

zdlee_*66937

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

Hi @zdlee ,

 

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