Use the Excel 2013 function to automatically enter any date

When creating a job document, you often want to display a specific date and time, not the actual date.This time, we will introduce a function that displays any date!

■ Control the date display freely. Functions that display the actual date and time, such as “NOW” or “TODAY”, are convenient to automatically update the date of date, but are not suitable if you want to display any date.is.When creating documents like an invoice, there are many cases where you want to change only the moon part without changing the date.In such a case, the perfect "Date" function is.It is a function that can specify any date based on the actual date, and can specify a certain date, such as 25th every month.Master the Date function and control the date display without input.

■ Display the date freely using the Date function In the setting of the Date function, there are three items, a year, month, and day, and add a formula in addition to the date display functions such as YEAR and MONTH.Displays any date.The date of the reference cell can be changed freely, one month or a few months after the next day or the day before.

Point01 Set the reference cell for reference by the Date function

↑ Enter the “Now” function that displays the actual date in the cell you use.

↑ When you enter "= now ()" and confirm it, the current date is displayed on the cell.

↑ Specify the cell you want to make an arbitrary date.The same cell as the reference cell cannot be selected.

↑ The function search window is displayed by “inserting functions” on the “formula” tab.

POINT02 Call a wizard for setting Date function

↑ In the search of the function, enter "Date" and select the "Search" button.Select Date from the result of the "function name" item.

↑ The Wizard of the Date function is displayed.Each of the input box is prepared for the year and can be set individually.

Point03 Display the year using the year function

↑ First, enter the function “Year ()” that displays the year in the “year” item box.Then, specify the coordinates of the reference cell in parentheses.

↑ Enter the coordinates of the reference cell set in POINT1 in parentheses.Here, the same display contents as the current date are specified without any particular change.

POINT04 Formula is added and the monthly display is changed to any month

↑ Next, set the moon display.After entering "month ()" in the "moon" item, specify the coordinates of the cell, which is the same as the "year" item.

↑ After entering the coordinates, add “+1”.Add a formula at the end of the formula to display the next month of the standard date.

POINT05 Enter the numerical values and fix the date to be displayed

↑ “Daily” does not enter functions or formulas, but only the numerical value is entered.By entering only the numerical values, the displayed date is fixed.

↑ After entering all items, click the “OK＂ button and determine the input.The 15th of the following month is displayed, not the actual date.