Required Date wise Data

[Rahul Mishra]

Dear Team,

Now i am uploading a excel file, in this i required date wise dynamically data.

 

[pecoflyer]

Please explain in words what you are trying to do, there is no explanation whatsoever in your example

 

[vletm]

Rahul Mishra
Something like this
... based Your given details.

 

[Rahul Mishra]

i required that data for example i attached filed pls help me in it

 

[vletm]

Rahul Mishra
You seems to clear something which gives #N/A for Your formulas D4:E9.
... There could use IFERROR-function to avoid #N/A.
Or
Do You really mean that You cannot Yourself use/modify my given formulas, if those should give/use something instead of Your formulas?
Your only data is in cell AA16 ... You can get it by selecting 06-Mar-22 with cell F2.