Moving cell data according to date

[manishman]

Hi all,

I'm a noob at excel and not entirely sure if this is possible to achieve. Will try my best to explain what I'm after using steps.

1. I want a 14 period to always show up and would like 'today's date' (whatever that may be) to always be fixed somewhere in the middle.
2. As the date changes, 'today's date' will change but remain in the same position. The oldest date get's deleted on the far left and a new date gets added on the far right to maintain that 14 day period.
3. The data in the specific date columns from ROW 2 to 6 will move with the date and eventually gets deleted when it reaches the far left. When the new date is added on the far right, new data will be added manually.
4. Column E would be frozen at all times.

sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1
2						11-Mar-21	12-Mar-21	13-Mar-21	14-Mar-21	15-Mar-21	16-Mar-21	17-Mar-21	18-Mar-21	19-Mar-21	20-Mar-21	21-Mar-21	22-Mar-21	23-Mar-21	24-Mar-21
3					DAYS:	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed
4
5					Agent 1														2
6					Agent 2	3	6	6		3			3.5	6				3
7
8					Sun-Sat
9					Mon-Sun
10					Tue-Mon
11					Wed-Tue
12					Thu-Wed
13					Fri-Thu
14					Sat-Fri
15					Sun-Sat
16
17
Sheet3

Cell Formulas
Range	Formula
F2:K3	F2	=G2-1
L2:L3	L2	=TODAY()
M2:S3	M2	=L2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
P2,P4:P6	Dates Occurring	today	text	NO
L3,F2:S2	Dates Occurring	today	text	NO