Help on formula

Using Formula =If(weekday(RefDate,2)=2,Refcell,DoNotChange)
How do I have not change the number it got on Tuesday on
Wednesday? Thank for your help

If the RefDate is entered/pasted, etc., it should not change. If it is
returned by TODAY() or NOW() or Date (VBA), you will have to change it to a
static date. Either of two ways: Edit>Copy>Edit>Paste Special>Values>OK or
Ctrl+; (Windows). There are other ways as well.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sam" <anonymous@discussions.microsoft.com> wrote in message
news:041001c3b383$de828810$a101280a@phx.gbl...
> Using Formula =If(weekday(RefDate,2)=2,Refcell,DoNotChange)
> How do I have not change the number it got on Tuesday on
> Wednesday? Thank for your help

Let me clarify,
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. Thanks for your help.





>-----Original Message-----
>If the RefDate is entered/pasted, etc., it should not
change. If it is
>returned by TODAY() or NOW() or Date (VBA), you will
have to change it to a
>static date. Either of two ways: Edit>Copy>Edit>Paste
Special>Values>OK or
>Ctrl+; (Windows). There are other ways as well.
>
>--
>Greeting from the Gulf Coast!
>http://myweb.cableone.net/twodays
>"Sam" <anonymous@discussions.microsoft.com> wrote in
message
>news:041001c3b383$de828810$a101280a@phx.gbl...
>> Using Formula =If(weekday(RefDate,2)
=2,Refcell,DoNotChange)
>> How do I have not change the number it got on Tuesday
on
>> Wednesday? Thank for your help
>
>
>.
>