Home > DeveloperSection > Articles > TODAY FUNCTION in Excel

TODAY FUNCTION in Excel


Excel Excel 
Ratings:
1 Comment(s)
 1935  View(s)
Rate this:

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


Hello AVADHESH PATEL

By Horas Panjaitan on   2 years ago
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




Don't want to miss updates? Please click the below button!

Follow MindStick