Forum Discussion

vtyree's avatar
vtyree
Copper Contributor
Jul 08, 2020
Solved

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 

If you mean the same date for all sheets, you may select all shift (click on first, Shift, click on last) and enter the date into the cell. Unselect sheets.

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

    I mean, a different date on each sheet...for example 7/1/20, 7/2/20 and so on. SergeiBaklan 

Resources