How can change data every 5 days?

[ngocanh87]

Hello all,

Data at M4,L4 change every 5 days: 1-5,6-10...,26-end

Day 01Feb, at E6=$M$4, E7=$L$4,
Day 06Feb, at F6=$M$4, E7=$L$4
...
Day 26Feb, at J6=$M$4, E7=$L$4

How can use vba or formula to change data of E6,F6..J6 follow M4,L4. Thank all

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	KẾT QUẢ SẢN LƯỢNG VÀ ĐƠN GIÁ 2023									14/02/2023
2												VND => USD	SUM WEIGHT
3	KẾT QUẢ KINH DOANH THÁNG 02								Unit / ĐVT：MT; USD	【確定計数】
4			Budget (Dự toán)	Transit Goods (Hàng đi đường)	5日 (01 -05)	10日 (06 - 10)	15日 (11 - 15)	20日 (16 - 20)	25日 (21 - 25)	28日 (26 - 28)		2137280,409	2029,712
5
6	Weight Shipment / Trọng lượng			-	2.030	2.030	2.030	2.030	2.030	2.030
7	Amount / Thành tiền			-	2.137.280	2.137.280	2.137.280	2.137.280	2.137.280	2.137.280
8	Price/ Đơn giá			-	1.053	1.053	1.053	1.053	1.053	1.053
Sheet1

Cell Formulas
Range	Formula
J1	J1	=TODAY()
E6:J6	E6	=$M$4
E7:J7	E7	=$L$4
E8:J8	E8	=E7/E6

 

[Legacy 143009]

Different approach:

E6=IF(CEILING(DAY(TODAY())/5,1)=COLUMN(A1),$M$4,"")

 

[ngocanh87]

Sorry I type at E6 error

 

[Legacy 143009]

Try using ";" instead of ",". I don't know. Maybe it is something about your regional settings.

 

[ngocanh87]

Oh it worked, but how can I fix formula by value.
Ex: this form I will user for month, today 14Feb G6: 2030. If today 16Feb how data at G6 will not change ? thank you

 

[Legacy 143009]

Do you want old data ro remain there?

 

[ngocanh87]

Yes, this is my mean, I want keep old data to remain

 

[Legacy 143009]

Then:

E6=IF(CEILING(DAY(TODAY())/5;1)>=COLUMN(A1);$M$4;"")

 

[ngocanh87]

Oh, it works perfectly. Thank so much

 

[Legacy 143009]

Thanks for the feedback