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.
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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
