Automatic change of cell contents according to date

[seanxx]

Hello,

I want to ask you for help
what formula to use if I would like to set the AUTOMATIC CHANGE of the cell contents according to the DATE.

Well thank you

autmatic change ako.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2		how to set automatic change of cell content according to date?										1.	2
3											31.12.2023	100	600
4											31.12.2024	200	700
5				TODAY							31.12.2025	300	800
6				16.3.2024	31.12.2024	= L4					31.12.2026	400	900
7		e.g.	D6=*TODAY *date dynamically								27.3.2027	500	1000
8			E6=final date
9			F6=L4 should remain the same only until 31.12.2024
10		then	*how to set the content in the cell to AUTOMATICALLY change on 1/1/2025:								31.12.2027
11			E6=31.12.2025								31.12.2028
12			F6=L5 should remain the same until the end of 12/31/2025								31.12.2029
13		....									31.12.2030
14											31.12.2031
15											31.12.2032
16											31.12.2033
17											31.12.2034
Hárok1

Cell Formulas
Range	Formula
D6	D6	=TODAY()

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you want? You can test by manually entering different dates in D6.

24 03 16.xlsm
	D	E	F	G	H	I	J	K	L	M
1
2									1	2
3								31/12/2023	100	600
4								31/12/2024	200	700
5	TODAY							31/12/2025	300	800
6	16/03/2024	31/12/2024	200					31/12/2026	400	900
7								27/03/2027	500	1000
seanxx

Cell Formulas
Range	Formula
D6	D6	=TODAY()
E6	E6	=DATE(YEAR(D6),12,31)
F6	F6	=VLOOKUP(E6,K3:L7,2)

 

[seanxx]

Navrhujem, aby ste aktualizovali podrobnosti o svojom účte (alebo kliknite na svoje používateľské meno v pravej hornej časti fóra), aby pomocníci vždy vedeli, aké verzie a platformy Excelu používate, pretože najlepšie riešenie sa často líši podľa verzie. (Nezabudnite sa posunúť nadol a 'Uložiť')

toto chceš? Môžete otestovať manuálnym zadaním rôznych dátumov v D6.

#VALUE!

Cell Formulas
Range	Formula
D6	D6	=DNES()
E6	E6	= DATE(YEAR(D6);12;31)
F6	F6	=VLOOKUP(E6, K3:L7,2)

perfektné
funguje to,
Ďakujem mnohokrát
Ešte sa spýtam, či je to možné, keď by som to chcel použiť v rôznych kombináciách.
(príklad=žlté bunky v prílohe)

 

[Peter_SSs]

Please post in English only in this forum.

 

[seanxx]

Please post in English only in this forum.

View attachment 108462

I apologize

perfect
it works,
Thank you very much
I will ask again, is it possible when I would like to use it in different combinations.
(example=yellow cells in the attachment)

 

[seanxx]

I apologize

perfect
it works,
Thank you very much
I will ask again, is it possible when I would like to use it in different combinations.
(example=yellow cells in the attachment)

one more question

XL2BB can only be used once when writing in a post?
XL2BB No more when answering?
When answering, I will offer to attach only a image.
thank you

 

[Peter_SSs]

XL2BB can only be used once when writing in a post?
XL2BB No more when answering?
When answering, I will offer to attach only a image.

No, XL2BB can be used multiple times in a post or thread so please use XL2BB, not an image that cannot be copied from.

If you have tried to use XL2BB again and run into problems, please explain exactly what you have done and what went wrong (eg error message etc).
There is a Test Here forum if you need to do some experimenting with XL2BB.

When you can post the sample data with XL2BB I will look at your last question.

 

[seanxx]

Can I still ask, if there is a solution, for help with the examples (blue cells) in the attachment?

thank you

date auto tex ENt.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1
2
3								TODAY
4								17.3.2024		28.2.2024
5
6											AUTOMATIC SUPPLEMENT = when "J4=28.2.2024" (changes automatically), then there will be "Q6", when "J4=28.2.2025" (changes automatically), then there will be "Q7" when "J4=28.2 .2026" (changes automatically) = so there will be "Q8,...."						100	500		text1
7											AUTOMATIC SUPPLEMENT = when "J4=28.2.2024" (changes automatically), then there will be "Q6+R6", when "J4=28.2.2025" (changes automatically), then there will be "Q7+R7", when "J4=28.2.2026" (changes automatically) = so there will be "Q7+R7,..."						200	600		text2
8											AUTOMATIC SUPPLEMENT = when "J4=28.2.2024" (changes automatically), then there will be "T6", when "J4=28.2.2025" (changes automatically), then there will be "T7" when "J4=28.2 .2026" (changes automatically) = so there will be "T8,...."						300	700		text3
9											AUTOMATIC SUPPLEMENT when the end of the last CHANGE is set to 28.2.2027 and it does not continue = when "J4=28.2.2024" (changes automatically), then there will be "T6" when "J4=28.2.2025" (changes automatically) , then there will be "T7", when "J4=28.2.2026" (changes automatically) = there will be "T,..."						400	800
10											AUTOMATIC SUPPLEMENT between the dates when START is set to 28.2.2024 and the end of the last CHANGE is 28.2.2027 and does not continue =when "J4=28.2.2024" (it changes automatically), so there will be "T6" when "J4=28.2 .2025" (changes automatically) , then there will be "T7", when "J4=28.2.2026" (changes automatically) = then there will be "T7,...."
11
12
Hárok1

Cell Formulas
Range	Formula
H4	H4	=TODAY()
J4	J4	=DATE(YEAR(H4)-IF(H4<=DATE(YEAR(H4),2,28),1,0),2,28)

 

[Peter_SSs]

Thanks for the XL2BB sample but unfortunately it looks not much at all like the image in post #5 and I don't really know what you are trying to do.
If you re-post, please do not include your explanations in the sheet, but do so in the body of your post. The XL2BB Mini Sheet should just contain the sample data (and the expected results manually filled in if possible)

Also, when creating a Mini Sheet, hide any irrelevant columns first and/or just select the applicable range. For example for the post #8 Mini Sheet you only needed to select H3:T10

 

[seanxx]

Thanks for the XL2BB sample but unfortunately it looks not much at all like the image in post #5 and I don't really know what you are trying to do.
If you re-post, please do not include your explanations in the sheet, but do so in the body of your post. The XL2BB Mini Sheet should just contain the sample data (and the expected results manually filled in if possible)

Also, when creating a Mini Sheet, hide any irrelevant columns first and/or just select the applicable range. For example for the post #8 Mini Sheet you only needed to select H3:T10

I apologise,

I did not know that a request or an explanation is not written in the minisheet and cell.

I will edit the mini sheet so that it is correct and create a new thread.

thank you