Ever tried to get your age directly from your date of birth?!

This is the formula: –=IF(MONTH(TODAY())>MONTH(A2),YEAR(TODAY())-YEAR(A2),IF(AND(MONTH(TODAY())>=MONTH(A2),DAY(TODAY())>=DAY(A2)),YEAR(TODAY())-YEAR(A2),YEAR(TODAY())-YEAR(A2)-1))

Simply put in your Date of birth in A2 cell, and type this formula in any other cell.
You ‘ll get your age 🙂