Excel help :(

by Rayzed • 6 Jul 2012, 02:03 • Journals
Hey crossies,

I really need some help with Excel and google didnt really help me out.

The problem:
I have a date of birth in A1 and need to see on which date the person turns X (lets say 25) years old.
Maybe even with an IF-function:
The date when the person turns X years old and a text-output when the person already is over that date.
I already tried a lot of things but simply cant figure it out.

Maybe someone here can help me out.


Regards,

Rayzed

P.S.
Cu@LAN


image: webfail-post-7
Comments
7
▼
Deactivated7001 6 Jul 2012, 03:12
Sounds kinda easy tbh. Let me get a coffee and I'll try it.

Edit:

Wenn ich dein Problem richtig verstanden habe, sollte es so funktionieren:

image: excel2zvelf
image: excel1grchq

C2: =WENN(DATUM(JAHR(A2)+B2;MONAT(A2);TAG(A2))>HEUTE();DATUM(JAHR(A2)+B2;MONAT(A2);TAG(A2));"Mist")
▼
zadd 6 Jul 2012, 03:50
open office calc:
=IF(TODAY() > EDATE(A1;12*25); "PAST - 25th birthday: "&TEXT(EDATE(A1;12*25); "TT.MM.JJJJ"); "FUTURE - 25th birthday: "&TEXT(EDATE(A1;12*25); "TT.MM.JJJJ"))

edit:
image: blacalcsckz0
▼
ipod 6 Jul 2012, 03:53
If you look to Artstar's profile, he gave one of his mates a shoutout to him also calling him an "excel wizard", message him.
▼
Brisk 6 Jul 2012, 04:41
#excel qnet & gsurge, they'll have the answers for sure.
▼
overdrive 6 Jul 2012, 06:11
google.be/search?sugexp=chrome,mod=12&sourceid=chrome&ie=UTF-8&q=The+date+when+the+person+turns+X+years+old

first result is what you are looking for
Back to top