=MONTH(TODAY()) : TODAY « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. TODAY
Input the formula: =MONTH(TODAY())
Input the formula: =MONTH(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()