TODAY Function

Basic Description

The Excel Today function returns the current date. The function has no arguments and therefore, the syntax of the function is simply: TODAY()


Today Function Examples

The following spreadsheets show 2 simple examples of calls to the Today function, which were made on 22th January 2015. The first example shows the function used alone, and the second example shows the function used as a part of a formula that calculates the number of days that have passed since 31-Dec-2014. The spreadsheet on the below shows the format of the formulas and the spreadsheet on the right shows the results.

1 =TODAY()
2 31-Dec-2014 =TODAY() – A2
1 22-Jan-2015
2 31-Dec-2014 22


Common Problem

When you attempt to subtract another date from the result the Today function, (as in cell B2 of the example above), the result looks like a date (eg. “1/22/1900”), instead of returning an integer.

Possible Reason

This problem arises because the new cell or column is formatted as a ‘date’. In this case, it is only the formatting of the cell that is wrong, NOT the value returned by the function.

To correct this:

  • Highlight the cell(s) with the wrong formatting
  • Right click with the mouse
  • Select the Format Cells … option and ensure the Number tab is selected
  • Under the Category heading, select the option General and click OK


Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment