How do I convert a formula that outputs month number and year joined together with each other using a hyphen and change that into underscore. The formula I have is important because when last month of the year is reached, the plus 1 then gives me next year's date e.g. 01-2022
A3 = TEXT(DATE(A2,A1+1,1),"mm-yyyy")
A1 = 01
A2 = 2021
Current output = 01-2021
Desired output = 01_2021
Thanks.
A3 = TEXT(DATE(A2,A1+1,1),"mm-yyyy")
A1 = 01
A2 = 2021
Current output = 01-2021
Desired output = 01_2021
Thanks.