Formula help

The formula I am using (If(weekday(RefDate,2)=2,Refcell)
is used to copy a number from one cell to another on
Tuesday. The problem I am having is that on every day
except Tuesday, the cell is cleared. I want the number
that is gathered on Tuesday to remain in that cell until
the next Tuesday. What can I add to the formula to make
this happen?

Thanks for your help.

You can play with this...I am not sure exactly what you need.
=IF(AND(WEEKDAY(A1=2,A1<=TODAY())),A1,"")

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Chris" <anonymous@discussions.microsoft.com> wrote in message
news:079f01c3b3a5$bb2362a0$a101280a@phx.gbl...
> The formula I am using (If(weekday(RefDate,2)=2,Refcell)
> is used to copy a number from one cell to another on
> Tuesday. The problem I am having is that on every day
> except Tuesday, the cell is cleared. I want the number
> that is gathered on Tuesday to remain in that cell until
> the next Tuesday. What can I add to the formula to make
> this happen?
>
> Thanks for your help.
>