Auto fill weekdays, months or years You can use the Excel Auto Fill options as described above. ... Another way is to enter your first date, select that cell, click the right mouse button and drag the fill handle down the cells you want to auto fill with dates, and then release it.
Insert a static date or time into an Excel cell On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). ( Windows) To insert the current time, press Ctrl+ Shift+; (semi-colon).
Click in the cell where you want to insert the current date, and then click the “ Formulas” tab on the command ribbon. Click the “ Date & Time” button in the Function Library group, and then click “ NOW” to open the Function Arguments dialog box.
Combine Cells With Text and a Formatted Date Select the cell in which you want the combined data. Type the formula, with text inside double quotes, and the date inside the TEXT function. For example, to show the full weekday name, for the current date: ... Press Enter to complete the formula.
Enter this formula = A2&" " & TEXT( B2,"mm/dd/yyyy") into a blank cell besides your data, see screenshot: 2. Then drag the fill handle down to the cells to apply this formula, and you can see, the text and date have been combined together in one cell.
Enter date values quickly using these Excel tricks Select a cell and press [ Ctrl]+; to enter the current date. Using the right mouse button, drag the fill handle down several cells and release. When you do, Excel displays a context menu. Select the appropriate option. For instance, choose Fill Months to increase the month value in your date series.
To use the Fill command, do the following: Starting with the cell that contains the first date, select the range of cells that you want to fill with the sequential list of dates. On the Home tab, in the Editing group, click Fill, and then click Series.
If you want to add months, years or days to a date or dates, you can apply a simple formula. Select a blank cell next to the date you use, type this formula = DATE( YEAR( A1), MONTH( A1)+1, DAY( A1)) and then press Enter key, drag fill handle over the cells you need to use this formula.