Forum Discussion

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
Jul 08, 2020
vtyree

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

=DATE(2020,7,SHEET()-1)

SergeiBaklan

Diamond Contributor

Jul 08, 2020

vtyree

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

=DATE(2020,7,SHEET()-1)

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
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.