Date & using if formula

M

magician_s

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
 
M

Max

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
 

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.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Using a Date and corresponding weekday to pull amounts 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
average hourly output for date, result shown by day 5
Use TODAY() function as the criteria in a SUMIF formula 1
Search closest day in the past from today 2
conditional format of adjacent cell with different range and crite 1
Shift Schedule Formula 1

Top