Sequential date on separate spreadsheets

[Hadorian]

Hi!

As i was trying to scan online for a solution, i couldn't find unique solution.
I am trying to create a template for a range of spreadsheets that would be used as a dailly planner for 365 days in a year, 2025.to be specific.
What i want to automate is date that would sequentally rise by 1 for each consecutive spreadsheet. The easiest thing would be to put the date in the header, but i believe this complicates things.
But i was thinking to choose cell A1 on each spreadsheet for the date position.
I tried one code, but it just gave #name error, so i seek for a valid solution.

Thanks!

 

[MARK858]

What are the names of your sheets?

 

[Hadorian]

Sheets are named Day1, Day2, Day3,...

 

[MARK858]

Try...
1) First you must save your workbook
2) Select all your sheet tabs
3) Paste the formula below in cell A1 of whichever sheet is active and press Enter
4) Deselect your sheet tabs

=DATE(2025,1,REPLACE(REPLACE(CELL("filename",A2),1,SEARCH("]",CELL("filename",A2),2),""),1,3,""))

 

[MARK858]

As you are using 365 then you can replace the formula in my previous post with the formula below (the steps are still the same)

=DATE(2025,1,REPLACE(TEXTAFTER(CELL("filename",A2),"]"),1,3,""))

 

[Peter_SSs]

IF these daily sheets are the first (left-most) sheets in the workbook then this should work no matter the names of the individual sheets.

1. Select all these daily worksheets
2. Select cell A1 in the active sheet
3. Enter this formula
   

   =DATE(2025,1,SHEET(TEXTAFTER(CELL("filename",A1),"]")))

4. While A1 is still selected (& all the worksheets) I would recommend Copy -> PasteSpecial - Values so the dates "stick" even if the sheets are reordered or new sheets introduced at the left.
5. Deselect your group of sheet tabs

 

[Hadorian]

Thank you for the reference, but neither works, there is an error in the formula.

 

[MARK858]

The formula I posted works fine for me

date file.xlsb
	A	B
1	11/01/2025
2
Day11

Cell Formulas
Range	Formula
A1	A1	=DATE(2025,1,REPLACE(TEXTAFTER(CELL("filename",A2),"]"),1,3,""))

As does Peter's

date file.xlsb
	A
1	02/01/2025
Day2

Cell Formulas
Range	Formula
A1	A1	=DATE(2025,1,SHEET(TEXTAFTER(CELL("filename",A1),"]")))

Are your separators normally comma's in your version?

 

[Hadorian]

You are right, i replaced commas with semicolons and it worked like a charm on both.

I guess this solves it.
I appreciate the assistance on my issue and thank you for it.

 

[MARK858]

You're welcome, happy we could help