fengliangduck
New Member
- Joined
- Aug 1, 2022
- Messages
- 2
- Office Version
- 365
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'))
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'))