I have date in text format as 20200612, 20201207 (yyyymmdd) I want to add 12 months to1st of next month date. The date should be 20200630 for 20200612
and for 20201227 date should be 20120131.
sample file is attached formula required to get data as shown in green colour.
and for 20201227 date should be 20120131.
sample file is attached formula required to get data as shown in green colour.