TODAY FUNCTION in Excel

In this article I have described how to used TODAY function in Excel Sheet. The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals. For example, if you know that someone was born in 1986, you might use the following formula to find that person's age as of this year's birthday:

=YEAR(TODAY())-1986

Note:

TODAY function returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format to Date. If you want to view the serial number, you must change the cell format to General or Number.

Syntax

TODAY( )

 

TODAY FUNCTION in Excel

  1. I know the first week and last week in xls formula


    example 

    cells A1 = 02/05/2014


    I want to display the week of December 02, it was the first week in these five



Leave Comment