sheet name into cell

[JOEE1979]

My sheet names are years (2024, 2025, 2026....)
In column A, I would like to put the date starting with 1 Jan and use the sheet name to make the year.
I would like this to continue all the way to 31 Dec (sheet name)

Is this possible?

 

[JOEE1979]

Here's the first result from a Google search.

You must refresh the calculations every time you're on a certain sheet to get the correct year. Otherwise, the year will show whatever the last time you refresh the calculation.
For example, if I ran the above formula for "2024", if I go to "2025". All the dates will show "2024", I must refresh to get 2025. Now if I go back to 2024, it says 2025.

In short, not a good idea because it can have unexpected consequences.

good to know,,,

I have changed the way I want it due to volatility,
but now I'm having a problem with the date
The year doesn't match up

Project tracker (1)1111.xlsx
	P	Q	R	S
6	January 1, 1905	1	1	2025
2025

Cell Formulas
Range	Formula
P6	P6	=DATE(YEAR(S6),MONTH(Q6),DAY(R6))

 

[Cubist]

The function YEAR(),MONTH(), DAY() are used to extract from a date series. What you have is not a date series, so those are unnecessary.

JOEE1979.xlsx
	P	Q	R	S
6	1/1/25	1	1	2025
Sheet3

Cell Formulas
Range	Formula
P6	P6	=DATE(S6,R6,Q6)

 

[JOEE1979]

It worked, but I have 1 more thing to ask, not sure if I'm supposed to open a new disscussion or not.

I have this formula to continue my tracking from the previous year

=SUMIFS('2024'!B:B,'2024'!J:J,@G:G,'2024'!N:N,@N:N)

I have tried to change it to this

=SUMIFS('(TEXT(A1, "0000")-1)'!B:B,'(TEXT(A1, "0000")-1)'!J:J,@G:G,'(TEXT(A1, "0000")-1)'!N:N,@N:N)

"A1" is the current year, and I'm hoping to subtract 1 from that to get the previous year worksheet name

As I mentioned before, I would like to automate the worksheet as I go along the years with minimal changes

 

[JOEE1979]

It worked, but I have 1 more thing to ask, not sure if I'm supposed to open a new disscussion or not.

I have this formula to continue my tracking from the previous year

=SUMIFS('2024'!B:B,'2024'!J:J,@G:G,'2024'!N:N,@N:N)

I have tried to change it to this

=SUMIFS('(TEXT(A1, "0000")-1)'!B:B,'(TEXT(A1, "0000")-1)'!J:J,@G:G,'(TEXT(A1, "0000")-1)'!N:N,@N:N)

"A1" is the current year, and I'm hoping to subtract 1 from that to get the previous year worksheet name

As I mentioned before, I would like to automate the worksheet as I go along the years with minimal changes

Nevermind, I figured out to use INDIRECT,,,