formula get specific date based on date of computer

[abdelfattah]

hello
i need formula to specific date after calculate 12 months so i have date in column a and the result in column b so it a2 = 1/7/2019 and when add 12 months when date reaches before finish day it shows in b2 =1/7/2020 it supposes showing this date when date of computer becomes 30/06/2020 i would this formula is dynamic because i have many dates
input

1 .xlsm
	A	B	C	D
1	CURRENT DAY	A NEW DATE
2	01/07/2019
3	15/05/2018
4	10/01/2011
5
6
sheet3

output

1 .xlsm
	A	B	C	D	E
1	CURRENT DAY	A NEW DATE
2	01/07/2019	01/07/2020
3	15/05/2018	15/05/2019
4	10/12/2011	10/12/2011
5
6
sheet3

 

[Fluff]

If you cannot be bothered to answer my very simple question, then I cannot help you.

 

[abdelfattah]

i think answered your question as for my explanation first date 26/04/2020 end date 26/05/2020

 

[Fluff]

Then why didn't you say that, rather than making a half-mile long post, that made no sense to me.
How about
=IF(AND(EDATE(TODAY(),-13)<=A2,EDATE(TODAY(),-12)>=A2),EDATE(A2,12),"")

 

[abdelfattah]

sorry i say this which range i write this formula and which result show that

 

[Fluff]

You put it in any cell you want, currently it looks at A2 for the date

 

[abdelfattah]

it gives me this date 01/00/1900 that's why i asked about which cell

 

[Fluff]

Not for me it doesn't.

+Fluff New.xlsm
	A	B
1
2	25/04/2019
3	26/04/2019	26/04/2020
4	27/04/2019	27/04/2020
5	28/04/2019	28/04/2020
6	29/04/2019	29/04/2020
7	30/04/2019	30/04/2020
8	01/05/2019	01/05/2020
9	02/05/2019	02/05/2020
10	03/05/2019	03/05/2020
11	04/05/2019	04/05/2020
12	05/05/2019	05/05/2020
13	06/05/2019	06/05/2020
14	07/05/2019	07/05/2020
15	08/05/2019	08/05/2020
16	09/05/2019	09/05/2020
17	10/05/2019	10/05/2020
18	11/05/2019	11/05/2020
19	12/05/2019	12/05/2020
20	13/05/2019	13/05/2020
21	14/05/2019	14/05/2020
22	15/05/2019	15/05/2020
23	16/05/2019	16/05/2020
24	17/05/2019	17/05/2020
25	18/05/2019	18/05/2020
26	19/05/2019	19/05/2020
27	20/05/2019	20/05/2020
28	21/05/2019	21/05/2020
29	22/05/2019	22/05/2020
30	23/05/2019	23/05/2020
31	24/05/2019	24/05/2020
32	25/05/2019	25/05/2020
33	26/05/2019	26/05/2020
34	27/05/2019
35	28/05/2019
36
37
38
39
40
Main

Cell Formulas
Range	Formula
B2:B38	B2	=IF(AND(EDATE(TODAY(),-13)<=A2,EDATE(TODAY(),-12)>=A2),EDATE(A2,12),"")

What do you have in A2?

 

[abdelfattah]

nothing and i do that whit another workbook it gives me empty data in column b i do the same data in column a and the formula in col b

 

[Fluff]

If you have a blank cell in col A then col B will be blank, as shown in rows 36:38 in post#27