Date Formula..

[omairhe]

Hey all,

If I have a value in cell A1 = 11 and in cell A2 = 2020
And I put a formula in A3 = A1+1&"-"&A2
And this will output me 12-2020
However when I do the same when A1 = 12 and cell A2 = 2020
then the output will be 13-2020 instead of 01-2021

So my question is what formula can we put on A3 so that the month and year from cells A1 and A2 is output with an addition of one month?

Thanks and will appreciate.

 

[Tetra201]

Try

=TEXT(DATE(A2,A1+1,1),"mm-yyyy")

 

[omairhe]

Try

=TEXT(DATE(A2,A1+1,1),"mm-yyyy")

Yes.. works perfectly.
Thank you.

 

[Dave Patton]

If you want to have a Date (not Text) see below.

Date and Time.xlsm
	A	B
1	11	12
2	2020	2020
3	Dec 01, 2020	Jan 01, 2021
4
5	11
6	2020
7	12-2020	This text not a date
8
16e

Cell Formulas
Range	Formula
A3:B3	A3	=DATE(A2,A1+1,1)
A7	A7	=A5+1&"-"&A2

 

[Dave Patton]

Date and Time.xlsm
	A	B	C
1	11	12
2	2020	2020
3	Dec 01, 2020	01-2021	Custom format mm-yyyy
4
5	11
6	2020
7	12-2020	This text not a date
16e

Cell Formulas
Range	Formula
A3:B3	A3	=DATE(A2,A1+1,1)
A7	A7	=A5+1&"-"&A2