It is normal to add the date to a spreadsheet - quite often to indicate when the sheet was last updated. Excel has a number of date functions that make it easy to enter the date into a worksheet. Functions are just built-in formulas in Excel to make it easy to complete commonly performed tasks – such as adding the date to a worksheet. The TODAY function is easy to use because it has no arguments – which is data that needs to be supplied to the function in order for it to work. The TODAY function is also one of Excel's volatile functions, which means it updates itself every time the recalculates – which is usually ever time the worksheet is opened. The steps below will add the TODAY function to cell C2 of the worksheet. Click on cell C2 to make it the active cell.Click on the Formulas tab of the ribbon.Click on the Date & Time option on the ribbon to open the list of date functions.
Click on the Today function to bring up the Formula Builder.Click Done in the box to enter the function and return to the worksheet.The current date should be added to cell C2.If a row of hashtag symbols appear in cell C2 instead of the date after adding the TODAY function to that cell, it is because the cell is not wide enough to display the formatted data.Īs mentioned previously, unformatted numbers or text data spill over to empty cells to the right if it is too wide for the cell. Data that has been formatted as a specific type of number – such as currency, dates, or time, however, do not spill over to the next cell if they are wider than the cell where they are located. To correct the problem, widen column C using the method described in the preceding step of the tutorial.Ī named range is created when one or more cells are given a name to make the range easier to identify. Named ranges can be used as a substitute for cell reference when used in functions, formulas, and charts.
0 kommentar(er)
