Insert and Format the Date in Excel Cell
As for the dates that you insert into a cell in Excel 2013 then we have a number of ways to insert date. Excel assumes the date and "see" as a number. To display the correct date is necessary to format the cell into which we insert date. By default, Excel will recognize the date and it will automatically format the standard Date Format.
Date in Excel write in a way so that the data is separated by a slash or a hyphen in the form of 15/07/14 or 07-15-14 or 7-15-14.
In this way, data entry excel will understand that this is a date when we confirm entry into a Excel cell will automatically adjust as the date and aligned with the right edge of the cell.
Date in Excel can be a later modified in a way to select the column or range of cells in which we input the date, click on the cell that contains the Date, right-click to open the shortcut popup menu and select from the list of Format cells command.
At the newly opened dialog box, choose the Number tab and choose a Date Category. In the Type field choose the date format that we want. Another way is to immediately select the column in which we enter the date and set the date format.
Copy dates by days, work week, months, years using Fill Handle
If you want to copy a date by days, weekdays without a weekend, months or years then look at how to use the 'Fill Handle' grip, you can do it by copying. With Fill Handle we can copy one cell or range of cells.
Copy a date and create a date range day by day using the Fill Series
Copy a date and create a date range without a weekend, ie without Saturday and Sunday using Fill Weekdays
Copy a date and create a date range for each month of the year using Fill Months
Copy a date and create a date range for several years using Fill Years
Automatically enter today's Date using Excel functions
If you want to a worksheet that you open every day that you can display the current date and enter it personally when you open the workbook, for insert automatic date it is enough to enter in the cell Excel function =TODAY()
Also using the shortcut key combination or we can insert the current date in a cell.
- To insert the current date, press Ctrl+; (semi-colon).
- To insert the current time, press Ctrl+Shift+; (semi-colon).
- To insert the current date and time, press Ctrl+; (semi-colon), then press the Space, and then press Ctrl+Shift+; (semi-colon).
Custom User Date Formatting in Excel 2013
If you want to format a date a later then the dialog box Format Cells in the Custom category, you set your own user format that Excel 2013 allows. (see picture below)
Date in Excel you can formatting also, by Excel functions: TODAY, NOW, DATE, DAY, MONTH, etc. (see all other functions related to Dates in Excel)