Formula help

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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,"")
 
Back
Top