Copying a date down PART of a column

Copper Contributor

I have a spreadsheet with 1,800 records/rows.  I need to copy the value of the date (so it doesn't increase on every row) down the column to row 800, not the entire column.  Is there a way to do this?  Thanx

4 Replies


Enter the date in a separate cell, say Z1.

In the first cell where you want the date, enter the formula


Format the column with the formula as a date.

@Hans Vogelaar Thank you so much for your quick response.  I tried your formula, but I got #NAME?

What am I doing wrong?



Apparently you have an older version of Excel. SEQUENCE is available in Excel in Office 2021 and in Microsoft 365.

Let's say you want to enter the date in P3:P802.

Press F5 to activate the Go To dialog.

Enter P3:P802 in the box, then press Enter or click OK.

Press Ctrl+; to enter the current date, then press Ctrl+Enter to populate the entire selection.

You're awesome! Works great! I have 2013 (paid for) and I don't really want to pay for 365 every year.
Thank you so much for your help.