Forum Discussion

WTittle's avatar
WTittle
Copper Contributor
Nov 28, 2023

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?  Thanx

  • WTittle 

    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.

    • WTittle's avatar
      WTittle
      Copper Contributor

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

      What am I doing wrong?

      • WTittle 

         

        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.

Resources