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:

[Table="width:, class:head"][tr=bgcolor:#000000][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

1​

[/td][td=bgcolor:#4472C4]Today[/td][td=bgcolor:#4472C4]DOB[/td][td=bgcolor:#4472C4]Age[/td][td=bgcolor:#4472C4]FutureYears[/td][td=bgcolor:#4472C4]FutureAge[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

2​

[/td][td=bgcolor:#D9E1F2]

18/08/2019​

[/td][td=bgcolor:#D9E1F2]

16/03/1973​

[/td][td=bgcolor:#D9E1F2]

46​

[/td][td=bgcolor:#D9E1F2]

15​

[/td][td=bgcolor:#D9E1F2]

61​

[/td][td][/td][td]A2:[/td][td]=TODAY()[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

3​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]C2:[/td][td]=DATEDIF(B2,A2,"y")[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#000000]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]E2:[/td][td]=SUM(C2:D2)[/td][/tr]
[/table]