Trying to create 180 day sliding window centered on todays date

Hello,

I am trying to create a sliding 180 day window centered on the current date (using columns for the date and rows for the cells to be calculated) that will slide left automatically as the date changes. Currently, I am manually changing my reference columns each day. The workbook is two sheets, one where the reference data is located and a second where I am displaying the results. I am new to the advanced functions of excel and have been searching for a solution online with no luck so far. The code I am using to manually move the window:

Please Login or Register  to view this content.

I have attached the workbook. Any help would be greatly appreciated.
Thanks,
Jim

I appreciate the response. I don't really understand how to implement it though. I really am very new to the advanced functions of Excel. Is there any chance you can insert the correct code in my example workbook and re-post?
Once again, thanks.

This is great. I now understand more about the macro functions. The problem I am encountering now is that my actual worksheet is more complex than the example I uploaded. When I edit the "countcolor" macro in my other workbook the result cells show all zeros. The actual workbook is using a 365 day back and ahead for a 730 day total sliding window and is looking at 25 rows of data. I think the problem may lie in the offsets? Can you decode for me what this line of code is actually telling Excel to do?

Please Login or Register  to view this content.

The only part I understand is the > Now()-90 and the <Now() + 90.
I really appreciate the help.

I figured it out. It works great now. I really appreciate the help.

One more question. Is there any way I can allow a color outside of this sliding window to be counted elsewhere? Example: I am tracking number of days inside the window, but I still want colors that are 400 days in the future to be counted elsewhere, not on a sliding scale. If I can't do this on the same sheet, does the macro apply to the whole workbook or can different sheets have a different macro for "countcolor"?

Great. Thank you very much. I appreciate the help.