• Re: Calculate birth date from age

    From Sapsiz@21:1/5 to All on Tue Mar 7 04:12:29 2023
    Yes, the information provided in your initial statement is applicable to Microsoft Excel. Excel stores dates as serial numbers, with January 1, 1900 being the start date (serial number 1). Each day after that is represented by a sequential number, with
    December 31, 9999 being the last possible date (serial number 2,958,465).

    To calculate a person's age based on their birthdate, you could use a formula like:

    =DATEDIF(A1,TODAY(),"y")

    where A1 is the cell containing the birthdate. This formula calculates the difference between the birthdate and today's date in years. (Source: https://calculator.bot/age )

    Alternatively, you could use a formula like the one you mentioned in your initial statement:

    =(TODAY()-A1*365.25)

    This formula calculates the difference between today's date and the birthdate in days (by multiplying the number of years by 365.25), but as you noted, it may be off by almost a year due to the approximation of using 365.25 days per year.

    To display the result as a date, you can format the cell containing the formula as a date. However, for age calculations, it's more common to display the result as a number of years rather than a date. (Source: https://calculator.date/age/ )

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)