Increment Year in IF statement

[fengliangduck]

Hi,
I have a following IF statement and I totally enter 12 months manually 01-2022, 02-2022 ..... 12-2022. But, how to make year increment automatically. For example, IF "02-2022","02/28/2022". IF "02-2023","02/28/2023". IF "02-2024","02/28/2024". In short, I like to have this 202X and X will automatically change. Thank you !
=if(A1="02-2022","02/28/2022",If(A1="01-2022","01/31/2022,"0'))

 

[Z51]

Rather than using an IF statement, perhaps try

=EOMONTH(A1,0)

That will return the last day of the month referenced in cell A1, regardless of year. Format the cell with the formula as a date, of course.

 

[fengliangduck]

Rather than using an IF statement, perhaps try

=EOMONTH(A1,0)

That will return the last day of the month referenced in cell A1, regardless of year. Format the cell with the formula as a date, of course.

Thank you !!!