# Thread: I need with my friend Thanks: 0 Likes: 0

1. ## I need with my friend

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!AnJwxxiz0Ezpg8h3...oGgmA?e=8ydGh1

Thanks You

Thomas

2. ## Re: I need with my friend

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

3. ## Re: I need with my friend

Update file.

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

with formula you said

Thanks You

Thomas

4. ## Re: I need with my friend

Does it do what you want?

5. ## Re: I need with my friend

click on link. updated link.

6. ## Re: I need with my friend

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

7. ## Re: I need with my friend

it didn't work

8. ## Re: I need with my friend

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

9. ## Re: I need with my friend

Format E2 as General.

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

10. ## Re: I need with my friend

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)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•