calculate the month using Last working day of the year

Hi All,
Good Day..
I have a scenario where i have to update month using last working day of the year.

Date Result
Example 12/31/2024 Mar 25
12/30/2024 Feb 25
3/1/2025 Mar 25

i used the function =IF(WORKDAY(DATE(YEAR(NOW()),1,1),1)=A1,MONTH(A1+3),MONTH(A1+2)) seems it is wrong

i have attached the file for reference.

Thank you

.
If @Pete_UK is correct in interpreting what the OP wants, this shorter formula should also work...

Formula:

Please Login or Register  to view this content.

I would also note that it returns a real date (well, date serial number which can be Custom Formatted to display as desired) as opposed to a text date.