Re: Calculating Age

=DATEDIF(A1,DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODAY())),"Y")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mert" <Mert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:438D39C5-D714-4C6E-AE10-138EEA77CA13@xxxxxxxxxxxxxxxx
I want to calculate someone's age from a year not from today's date.

ie: the birthday is August 16, 1979 if we calculate from (today) it will
say 27 but i want to calculate from the year (2007) - so it will show 28


.

Relevant Pages

  • Re: Use Sort method for 2002/2003 in 2000.
    ... Bob Phillips ... in the email address with gmail if mailing direct) ... Again in Excel 2000 I get the msg that the variable xlSortTextAsNumbers ...
    (microsoft.public.excel.programming)
  • Re: any UDF for sum or rounded product
    ... to gmail if mailing direct) ... number of factors and decimals - like a generic/productive formula. ... "Bob Phillips" wrote: ...
    (microsoft.public.excel.programming)
  • Re: AVERAGE function
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... After posting, I went out for lunch (and a nice drop of Old Speckled ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting Values Across Columns
    ... to gmail if mailing direct) ... Bob Phillips Wrote:- ...
    (microsoft.public.excel.setup)
  • Re: Unique entry count
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... type an entry in A1. ...
    (microsoft.public.excel.misc)
Loading