date in every sheet

[AshAshAsh]

Hi,

Im making a calender with every day on a different sheet.

How do i put the date in every sheet automatically?

Like sheet one title is 01-01 

sheet two title 02-01

sheet three title 03-01

but id also like the date on the sheet itself

ive got the titles worked out, but how do i put every date automatically in the sheet?

[#2]

@AshAshAsh 

Re:  date on all sheets

Select the first sheet

Hold down the Shift key and select the last sheet.

(all sheets will then be selected)

In the appropriate cell enter the formula:   =TODAY()

The above creates the current date on every sheet.

The date just entered will update to the current date every day.

;---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

[#3]

@Nothing_Left_to_Lose 

okay but how do i change the date to future dates?
I dont want the date of the day i opened it if i have to plan for next week, if you know what i mean

[#4]

Repeating...
The formula entered "=Today()" will update to the current date every day
on every sheet..

If that isn't what you want, you can overtype the Today() formula on a particular sheet with the date you want