Counting your age, in days: =TODAY() - DATE(birth year, birth month, birth day) : TODAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =TODAY() -DATE(1956, 3, 18)
Input the formula: =TODAY() -DATE(1956, 3, 18)
15.14.TODAY
15.14.1.=TODAY() returns the serial number of today's date
15.14.2.Counting your age, in days: =TODAY() - DATE(birth year, birth month, birth day)Counting your age, in days: =TODAY() - DATE(birth year, birth month, birth day)
15.14.3.=MONTH(TODAY())=MONTH(TODAY())
15.14.4.Counting the days until your birthday: =DATE(2007,5,5) - TODAY()Counting the days until your birthday: =DATE(2007,5,5) - TODAY()