Date & using if formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magician_s - 13 Mar 2007 07:40 GMT

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

Reply to this Message

Max - 13 Mar 2007 08:43 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Gidday,
>
[quoted text clipped - 9 lines]
>
> Many thanks in advance

Reply to this Message