How to make a DATE, DATEVALUE formula?

[seanxx]

Could you please advise me how to make the correct formula?
When the date is changed according to the formula, the result does not change
Thank you

Zošit2
	A	B	C	D	E	F
1
2
3
4				22.12.2024
5
6				28.02.2024
7
8
9
10
11
Hárok1

Cell Formulas
Range	Formula
D4	D4	=TODAY()
D6	D6	=IF(D4>=DATE(2024,2,28),DATEVALUE("28.2.2024"),IF(D4>=DATE(2025,1,1),DATEVALUE("1.1.2025"),IF(D4>=DATE(2026,1,1),DATEVALUE("28.2.2026"))))

 

[HighAndWilder]

Could you please advise me how to make the correct formula?
When the date is changed according to the formula, the result does not change
Thank you

Zošit2
	A	B	C	D	E	F
1
2
3
4				22.12.2024
5
6				28.02.2024
7
8
9
10
11
Hárok1

Cell Formulas
Range	Formula
D4	D4	=TODAY()
D6	D6	=IF(D4>=DATE(2024,2,28),DATEVALUE("28.2.2024"),IF(D4>=DATE(2025,1,1),DATEVALUE("1.1.2025"),IF(D4>=DATE(2026,1,1),DATEVALUE("28.2.2026"))))

Try this. I have reversed your formula.

If the date is prior to 28/02/2024 what date do you want to be displayed?
If have inserted today's date but you may need to change this.

=IF($D$4>=DATE(2026,1,1),DATE(2026,2,28),IF($D$4>=DATE(2025,1,1),DATE(2025,1,1),IF($D$4>=DATE(2024,2,28),DATE(2024,2,28),TODAY())))

 

[Dave Patton]

T202412a.xlsm
	D	E	F	G	H
1					Date
2
3
4	21-Dec-24
5				28-Feb-24	28-Feb-24
6	28-Feb-24	28-Feb-24		1-Jan-25	1-Jan-25
7				1-Jan-26	28-Feb-26
8
4c

Cell Formulas
Range	Formula
D4	D4	=TODAY()
D6	D6	=IF(D4>=DATE(2026,1,1),DATE(2026,2,28),IF(D4>=DATE(2025,1,1),DATE(2025,1,1),IF(D4>=DATE(2024,2,28),DATE(2024,2,28))))
E6	E6	=LOOKUP(D4,G5:H7)

 

[seanxx]

@HighAndWilder
@Dave Patton
it's ok!
thank you very much for your help.
so in the formula the dates must be written in descending order?

 

[HighAndWilder]

T202412a.xlsm
	D	E	F	G	H
1					Date
2
3
4	21-Dec-24
5				28-Feb-24	28-Feb-24
6	28-Feb-24	28-Feb-24		1-Jan-25	1-Jan-25
7				1-Jan-26	28-Feb-26
8
4c

Cell Formulas
Range	Formula
D4	D4	=TODAY()
D6	D6	=IF(D4>=DATE(2026,1,1),DATE(2026,2,28),IF(D4>=DATE(2025,1,1),DATE(2025,1,1),IF(D4>=DATE(2024,2,28),DATE(2024,2,28))))
E6	E6	=LOOKUP(D4,G5:H7)

@HighAndWilder
@Dave Patton
it's ok!
thank you very much for your help.
so in the formula the dates must be written in descending order?

And you need to consider what result you want when none of the conditions apply.

 

[Alex Blakenburg]

The if statement stops when it finds a true condition so if you are using D4>=a date then you need it to be in descending order. Think of it as setting the bar high and then gradually lowering it until you have captured all your options.
If you are using D4<=a date, you want to go in ascending order. ie set the bar low and keep raising it until you have captured all the options.

 

[seanxx]

@Alex Blakenburg
yes,
thanks very much for the explanation

 

[Alex Blakenburg]

You're welcome.