Hi Bob.

7 days prior to the date selected. For example the user will select
the date in cell U4. I then need the cell S7 to change to 7 days prior
to the date selected in cell U4. The user could still go and select a
different date in cell S7, but as soon as they changed the date in U4
again, S7 would default back to U4 - 7.

Thanks.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=565876