Counting the days until your birthday: =DATE(2007,5,5) - TODAY() : TODAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =DATE(2007,5,5) - TODAY()
Input the formula: =DATE(2007,5,5) - TODAY()
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()