Date & using if formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Gidday,

I have used a formula to make the days show from the corresponding cells
above.

ie:
13/3/07 14/3/07
Tuesday Wednesday
I want value to be 0 Value to be 2.3
Now what I want to do is, for any tuesday, underneath the date shown for it
to have a value of 0 and every other day not tuesday to have a value of 2.3.

Many thanks in advance
 
One way ..

If real dates are entered in A1 across,
place in A3:
=IF(A1="","",IF(WEEKDAY(A1,2)=2,0,2.3))
Copy across as far as required
 
Back
Top