I am struggling to get this going.
So I have a date column which contains all the dates from 2018 till today.
Now my requirement is
1) If the date is of current year, then months column= Date month- last month of current year.
For example - If Date is 30/05/2022 then Months column should output= 7
2) if the date is of previous years, then months column output should be 12.
For example - If date is 30/05/2018 or 25/09/2019 etc for all these output months column should always be 12.
Can anyone please help ?