Forum Discussion
Copying a date down PART of a column
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...
Enter the date in a separate cell, say Z1.
In the first cell where you want the date, enter the formula
=IF(SEQUENCE(800),Z1)
Format the column with the formula as a date.