However, the data did not automaticaly update to the date format. Supposing you have created a chart to track the daily sales based on a range of data in your workbook.Here I can introduce you a complex dynamic formula method. First, you need to create a defined name and a dynamic formula for each column.
Options for entering the TODAY function include: Since the TODAY function does not have any arguments that can be entered manually, many people opt to just type in the function rather than use the dialog box.
As mentioned, if the TODAY function does not update to the current date each time the worksheet is opened, it is likely that automatic recalculation for the workbook has been turned off.
You can select a NOW function that displays the date and time for your regional settings, or the TODAY function that displays only the date.
You also have the option to change the date format to make it more meaningful to you.
Normally, worksheets recalculate each time they are opened so every day that the worksheet is opened the date will change unless automatic recalculation is turned off.
To prevent having the date change each time a worksheet using automatic recalculation is opened, try using this keyboard shortcut to enter the current date instead.Click the “Number” tab, click “Date” in the Category section, and then click your preferred format in the Type section.For example, click to select “March 14, 2012” and preview the date displayed in the Sample section. Enter data on the other worksheet cells, and then press “Enter” to update the date according to your computer’s system clock.TODAY uses the computer's serial date - which stores the current date and time as a number - as an argument.It obtains this information on the current date by reading the computer's clock.But you need to change or edit the number of the data every day, in this case, you have to update the chart manually so it includes the new data.