Forum Discussion

cschackle's avatar
cschackle
Copper Contributor
Mar 27, 2022

Formula for Multiple Date Cells

Hello Everyone,    I am trying to auto fill or auto populate (< I do not know if I am using the correct terminology) the same date in multiple different boxes that aren't under one another. I have ...
excel
Formulas and Functions
harshulz's avatar
harshulz
Iron Contributor
Mar 27, 2022

cschackle 

hi,
to my knowledge you need relative reference
like
A10 you input the date, and the for automate in cell A18... simply use formula write =A10
now copy this formula and paste where ever you need data.

once you update data in A10 it will update automatically

 

 

 

  • cschackle's avatar
    cschackle
    Copper Contributor
    Mar 28, 2022

    harshulz 

     

    Do you have to have a relative reference or in all the below cells can I just input the formula "=A10" in all the cells that need the formula. I know when I didn't put a relative reference in the boxes below it, it populated with a date from the 1900s. But changed once I added in today's date in the original A10 box. I just want to make the formula hidden and blank so no one can see it. 

     

    I ask because this spreadsheet is going to be shared amongst other people to add in their own information. So I would like all the boxes to be blank and then they are just able to fill in as they go. 

     

     

    • harshulz's avatar
      harshulz
      Iron Contributor
      Mar 31, 2022

      say you have once input cell ranged from A1:A5
      lets say you input from cell A1 to A5 as below
      3/22/2022
      3/30/2022
      4/1/2022
      4/13/2022
      4/25/2022

      now to automate to other places where ever you want, simply use formula
      =A1:A5



      as this file will share among other people, in that case you protect your cells. by protecting cell i means no one can change and no one can look up to formula. sample file attached below , where you cannot change dates.

Resources