I am trying to capture 3 percentage values every monday that will automatically be included on my time performance graph.

I set my date in C4 and calculation works, but I want to "capture" the value when the date matches and not lose it when the next day comes around.



B C C
4 2-Apr =B4+7 =B4+14 (and on and on)
=IF(TODAY()<>C$4,"",IF(TODAY()=C$4,'SUB CALCS'!$I4))

Any help is surely appreciated!!

Don