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

zdlee
New Contributor

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

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?

1 REPLY 1
Akhtar.shahbaz
Community Boss

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

Hi @zdlee ,

 

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

Screenshot_237.png