Ace My Paper - get your Excel tasks done by experts. - makes your homework shine.


Excel tutorials

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.

insert date in excel 2013

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.

format date in excel

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.

formatting date in excel

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 date by day 

Copy a date and create a date range without a weekend, ie without Saturday and Sunday using Fill Weekdays

 Copy dates by weekdays

Copy a date and create a date range for each month of the year using Fill Months

 Creating a date by months of the year

Copy a date and create a date range for several years using Fill Years

Quick creating a few years by first date of first month


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)

custom format date in excel 2013

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)