I need with my friend

[Legacy 420921]

My friend have today() in one cell. second column put birthday mm/dd/yy. Third column have future how year. fourth column is how old he will be in future age

here link to get the file

https://1drv.ms/x/s!AnJwxxiz0Ezpg8h3vO4Rqi1ekoGgmA?e=8ydGh1

Thanks You

Thomas

 

[Fluff]

How about
In C2
=YEAR(A2)-YEAR(B2)
In E2
=C2+D2

 

[Legacy 420921]

Update file.

https://1drv.ms/x/s!AnJwxxiz0Ezpg8h3vO4Rqi1ekoGgmA?e=mPLgTC


with formula you said


Thanks You

Thomas

 

[Fluff]

Does it do what you want?

 

[Legacy 420921]

click on link. updated link.

 

[Fluff]

No.
Please tell me if it worked & if not describe why.

 

[Legacy 420921]

it didn't work

 

[Fluff]

it didn't work

That is less than helpful, care to explain in what way it didn't work?

 

[shg]

Format E2 as General.

The formula in C2 should be =DATEDIF(B2, A2, "y")

 

[sandy666]

maybe:

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Today	DOB	Age	FutureYears	FutureAge
2​	18/08/2019​	16/03/1973​	46​	15​	61​		A2:	=TODAY()
3​							C2:	=DATEDIF(B2,A2,"y")
4​							E2:	=SUM(C2:D2)