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:



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.




  Modified On Nov-29-2017 10:29:44 AM
  1. I know the first week and last week in xls formula
    cells A1 = 02/05/2014

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

Leave Comment