B2=INPUT
B3 =INDEX(A1:G1, MOD(MATCH(B2, A1:G1, 0), COLUMNS(A1:G1)) + 1)
B4=INDEX(A1:G1, IF(MATCH(B2, A1:G1, 0)=1, COLUMNS(A1:G1), MATCH(B2, A1:G1, 0)-1))
Keep document that easy to find
B2=INPUT
B3 =INDEX(A1:G1, MOD(MATCH(B2, A1:G1, 0), COLUMNS(A1:G1)) + 1)
B4=INDEX(A1:G1, IF(MATCH(B2, A1:G1, 0)=1, COLUMNS(A1:G1), MATCH(B2, A1:G1, 0)-1))
CREATE TABLE record_packing_ok_2024 LIKE record_packing_ok;
INSERT INTO record_packing_ok_2024
SELECT *
FROM record_packing_ok
WHERE YEAR(date_time) < 2025;
DELETE FROM `record_packing_ok` WHERE year(`date_time`)<2025;