Find and Replace (with changing date) in macro

I am trying to automate a report update that requires a find a replace in the middle of the process and need it to use an updated date everyday. I tried to get it to record my copy/paste of the date cell to use in the find&replace...no luck. Also, tried to set the date cell as an active cell...no luck.

It just wants to hard code in the original dates I pasted into the Find&replace window. This is how it currently set up...

Selection.Replace What:="2011-0929", Replacement:="2011-0930", LookAt:= _
        xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Thank you