Forum Discussion
date in every sheet
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?
3 Replies
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)
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- 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
