Calculate Age

mpfeil45316
edited 12/09/19 in Smartsheet Basics

=IF(ISDATE(DOB1), IF(MONTH(DOB1) > MONTH(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), IF(MONTH(DOB1) = MONTH(TODAY()), IF(DAY(DOB1) > DAY(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), YEAR(TODAY()) - YEAR(DOB1)), YEAR(TODAY()) - YEAR(DOB1))), "")

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭
    edited 04/19/18

    Is this a helpful formula, or are you looking for assistance?

    If it's the former, thank you as I can see a formula like this being very handy. If it's the latter, then that is properly lazy.

    Either way, putting some more detail around what the formula represents would be great.

    Kind regards,

    Chris McKay