The TODAY() function always shows the date of the current day, no matter when you open it. That is what it is used for. Other elements of the spreadsheet can make use of it for their calculations.
The TODAY function, like this: =TODAY()
The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.
Excel [from Microsoft Office in Windows], Calc [from OpenOffice.org used mostly in Linux, but can be installed in Windows], & Numbers [from iWorks in Mac]
One way is to use the TODAY function :=TODAY()Any day you open a workbook with that in it, it will always show the current day. You can also use the NOW function, though that will also show the time. Another thing you can do is press and hold the Ctrl and Shift keys and press the ; key. That will put in the current date, though it will not update the date if the workbook is saved and opened on another day, unlike the TODAY function.
You can use the TODAY function or press and hold the Ctrl key and the ; key.
If you press the Ctrl key and the ; key, it will put in today's date. If you use the Today() function, it will always show the current date when a spreadsheet is opened. So in a cell you just have to put: =Today() Then no matter when you open the file it will always have the date of the current day in that cell.
As the third input parameter of the IF function, which is what to display if the first input parameter is false, insert another IF function. Example: ="It's " & IF(WEEKDAY(TODAY())=1,"Sunday!",IF(WEEKDAY(TODAY())=2,"Monday!",IF(WEEKDAY(TODAY())=3,"Tuesday!",IF(WEEKDAY(TODAY())=4,"Wednesday!",IF(WEEKDAY(TODAY())=5,"Thursday!",IF(WEEKDAY(TODAY())=6,"Friday!","Saturday!"))))))
Microsoft
The TODAY function can enter today's date in Excel. The DATE function can be used to build a date from the day, month and year elements.
A function is one specific function, like LEFT for getting a substring starting from the left, or TODAY for getting today's date, or SUM for getting the sum of some numbers. A formula is a combination of cell references, values, strings, and functions, used to define how to calculate the value to display in a cell.
formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)
Microsoft companies are located worldwide