A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005.This formula will use the TODAY function as an argument for the YEAR function to obtain the current year,and then subtract 2005 returning the person's age.

Question

Quizplus · Accepted Answer

The formula accurately calculates the age of a person born in 2005 by subtracting their birth year (2005) from the current year obtained from the TODAY function.

A Student Types the Formula '= YEAR( TODAY())-2005' to Calculate