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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"magician_s" wrote:
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