I think you should be able to do this yes, by modifying your formula in row 102 on Variance Tracking sheet such that it also validates date header falls within acceptable bounds... by last 30 - you mean 30 days from today backwards ? To help further we need to understand these boundaries more fully.
On an aside your existing formula in row 102:
Is volatile given use of INDIRECT etc... better I would say to use INDEX, eg:
so to reiterate the key will be to adjust the above to incorporate a further test which identifies header date to be valid but first we need to understand your time boundaries.
Bookmarks