Date after 12 month and year

[pmeghnathi]

Exp. A1 cell value 01/06/2020 than
A. B
Jul-20. Aug-20
Sep-20. Oct-20
Nov-20. Dec-20
Jan-21. Feb-21
Mar-21. Apr-20
May-21. Jun-21

 

[Joe4]

So what exactly is your question?

 

[pmeghnathi]

1	01/06/2020
2	Jul-20	Aug-20
3	Sep-20	Oct-20
4	Nov-20	Dec-20
5	Jan-21	Feb-21
6	Mar-21	Apr-21
7	May-21	Jun-22

 

[Joe4]

You still have not posted a question.
Please tell us EXACTLY what your question is.
What are youe expected results?

 

[pmeghnathi]

A1 cell enter value Date to a2 cell next month and year result

 

[MARK858]

A1 cell enter value Date to a2 cell next month and year result

Book1
	A
1	07/07/2020
2	07/08/2021
Sheet3

Cell Formulas
Range	Formula
A2	A2	=DATE(YEAR(A1)+1,MONTH(A1)+1,DAY(A1))

 

[Fluff]

Or maybe

+Fluff New.xlsm
	A	B
1	01/06/2020
2	Jul-20	Aug-20
3	Sep-20	Oct-20
4	Nov-20	Dec-20
5	Jan-21	Feb-21
6	Mar-21	Apr-21
7	May-21	Jun-21
Main

Cell Formulas
Range	Formula
A2:A7	A2	=EDATE(A$1,ROW(A1)*2-1)
B2:B7	B2	=EDATE(A2,1)

 

[pmeghnathi]

Book1
	A
1	07/07/2020
2	07/08/2021
Sheet3

Cell Formulas
Range	Formula
A2	A2	=DATE(YEAR(A1)+1,MONTH(A1)+1,DAY(A1))

Sorry my mistek
I want this
Exp. A1 cell value 01/06/2020 than
A. B
May-20 Apr-20
Mar-20 Feb-20
Jan-20 Dec-19
Nov-19 Oct-19
Sep-19 Aug-19
Jul-19 Jun-19
May-19

 

[Fluff]

How about

+Fluff New.xlsm
	A	B
1	01/06/2020
2	May-20	Apr-20
3	Mar-20	Feb-20
4	Jan-20	Dec-19
5	Nov-19	Oct-19
6	Sep-19	Aug-19
7	Jul-19	Jun-19
Master

Cell Formulas
Range	Formula
A2:A7	A2	=EDATE(A$1,1-ROW(A1)*2)
B2:B7	B2	=EDATE(A2,-1)

 

[pmeghnathi]

How about

+Fluff New.xlsm
	A	B
1	01/06/2020
2	May-20	Apr-20
3	Mar-20	Feb-20
4	Jan-20	Dec-19
5	Nov-19	Oct-19
6	Sep-19	Aug-19
7	Jul-19	Jun-19
Master

Cell Formulas
Range	Formula
A2:A7	A2	=EDATE(A$1,1-ROW(A1)*2)
B2:B7	B2	=EDATE(A2,-1)

very very thank you for the my help. Well come Gujarat