How to use TODAY function in excel

Excel version in which TODAY function can work:

TODAY function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010.

About TODAY function in excel:

This is a worksheet function. TODAY function returns the current system date in the cell. The current date will be updated in the worksheet when the workbook is opened, changed or calculation is performed in the workbook. Basically TODAY function returns serial date value, we can format the value returned by TODAY using any standard date format. If we want current time in addition to date we can use NOW function.

Syntax for TODAY :



TODAY function does not take any parameter in formula, however, we should put brackets with empty parameter.

Using TODAY function:

TODAY can be used to get current date in the cell, This also can be used to get the age as on date based on date of birth, current month,etc as below.

Date of birth Age as on date Formula
10-Apr-85 33.18  =(TODAY()-A2)/365


Leave a Comment

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