Help on formula

[Sam]

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

 

[Jim]

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.

 

[Sam]

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.