Nov 28 2023 10:43 AM
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
Nov 28 2023 11:42 AM
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.
Nov 28 2023 01:20 PM
@HansVogelaar Thank you so much for your quick response. I tried your formula, but I got #NAME?
What am I doing wrong?
Nov 28 2023 03:15 PM
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.
Nov 28 2023 03:34 PM