Re: How old are you?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ok.
No doubt.
From now on, I'll only take, and won´t try to give in this forum.
I suposed diversity in suggestions will give a wider panorama to the poster.
But as i could see, I am in diapers [it´s a modism, here in MX]

Kind regards, Most Very Perfect David

"David McRitchie" <dmcritchie_xlmvp@xxxxxxxxxxx> escribió en el mensaje
news:O0mpZGyNGHA.2696@xxxxxxxxxxxxxxxxxxxxxxx
There are several things wrong with your answer.
The poster did not ask for decimal fractions of age, you only have an
approximation.
The function NOW() includes both a date and time component.
There are not 365.25 days in a year, there are leap years, ages aren't
based on averages.
You did not test your answer, people are very particular about birthdays.


1990-04-01 2006-03-31 16.000 <-- incorrect, s/b 15.000
1990-04-01 2006-04-01 16.003 <-- 16th birthday, s/b 16.000
1990-04-01 2006-04-02 16.005 <-- incorrect
1991-04-01 2006-03-31 15.001 <-- incorrect
1991-04-01 2006-04-01 15.003 <-- 15th birthday, s/b 15.000
1991-04-01 2006-04-02 15.006 <-- incorrect
1992-04-01 2006-03-31 13.999 <-- incorrect
1992-04-01 2006-04-01 14.001 <-- 14th birthday , s/b 14.000
1992-04-01 2006-04-02 14.004 <-- incorrect
1993-03-31 2006-03-31 13.002 <-- incorrect
1993-04-01 2006-04-01 13.002 <-- 13th birthday, s/b 13.000
1993-04-02 2006-04-02 13.002 <-- incorrect
1990-04-01 2006-10-01 16.504 <-- incorrect

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Hernandez, Roberto" <m21477@xxxxxxxxxxxxxxx> wrote in message
news:11vmleh316lvsea@xxxxxxxxxxxxxxxxxxxxx
Hi,
I´d like to ask: what's incorrect in my answer?
I use this formula very often to calculate employees payments that are
directly related to their hiring date.
Of course I know DATEDIF function, but in this case I need age in
decimal
format.
And of course I do not think I'm giving 'incorrect' posts: We all try to
cooperate, I supose.
Kind Regards.


"David McRitchie" <dmcritchie_xlmvp@xxxxxxxxxxx> escribió en el mensaje
news:euh7rsuNGHA.3908@xxxxxxxxxxxxxxxxxxxxxxx
Hi Roberto,
what's that, an attempt at precision, without accuracy?
Look at the replies involving DATEDIF. Please don't post incorrect
answers, people are very particular about birthdates.

"Hernandez, Roberto" <m21477@xxxxxxxxxxxxxxx> wrote ...
Try this one[with Birth Date on A1]
=(NOW()-A1+1)/365.25








.

Relevant Pages

  • Re: Whos-been-posting-here-longer-than-who? (was:Hey, Im new to this...)
    ... :>| It's an easy term to use when you're scared of the poster just because ... Presumably age is catching up with him to an extent. ... of consideration was ever a factor when he routinely threatened violence ... A real class act all around, our petey boy. ...
    (rec.food.cooking)
  • Re: Chris Langham - child porn charge
    ... the actual age of the poster and the date it was taken is more or less irrelevant. ... The criteria are drawn so wide as to encompass just about anything. ...
    (uk.media.tv.misc)
  • Re: ABELARD pls reconsider quantity/quality balance in yr posts
    ... no need...i craft my posts according to the age, ability and ... aptitude of the poster to whom i am replying... ...
    (uk.politics.misc)
  • Re: Ann Coulter is a coward
    ... not a White House approved poster!" ... Incorrect. ... This afternoon, during my session with my psychotherapist, we talked about Chad. ...
    (rec.sport.pro-wrestling)
  • Re: phone number or phone numbers
    ... believe that their own native version of English is "correct" ... and that those other people across the pond are "incorrect". ... you're the only poster I can remember making this ... I don't think I use much breath to type, ...
    (alt.usage.english)