Forum Discussion

vtyree's avatar
vtyree
Copper Contributor
Jul 08, 2020

Entering a date on multiple sheets automatically

I'm trying to put in a formula to enter dates automatically on my sheets. For example: I have 31 sheets for the month of July. I want to have the date on each sheet in the same cell. Is there a way t...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 08, 2020

    vtyree 

    When simply select sheets 2-... and enter into the cell

    =DATE(2020,7,SHEET()-1)
SergeiBaklan's avatar
SergeiBaklan
MVP
Jul 08, 2020

vtyree 

When simply select sheets 2-... and enter into the cell

=DATE(2020,7,SHEET()-1)
  • jbalderas's avatar
    jbalderas
    Copper Contributor
    Dec 05, 2023
    where do you enter that? and i need it to be dated format like below 7/1/24,7/2/24. etc. but I need it dated not just 1,2,3, for dates.
    • vtyree's avatar
      vtyree
      Copper Contributor
      Dec 05, 2023

      jbalderas please see attached. Enter it in the box for the date you wish to use. Change the number to what ever month you are using. 

       

  • vtyree's avatar
    vtyree
    Copper Contributor
    Jul 10, 2020

    OMG thank you!!! It worked!!!! SergeiBaklan 

Resources