IF Q

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

How do I say the following

=IF(B8=Thursday,2,0) i.e. Return the value 2 if B8 returns
"Thursday"

Where B8 is a date but it is formatted to show the day


Thanks
 
Sean said:
How do I say the following

=IF(B8=Thursday,2,0) i.e. Return the value 2 if B8 returns
"Thursday"

Where B8 is a date but it is formatted to show the day
Click to expand...

=IF(TEXT(B8,"ddd")="Thu",2,0)

or

=IF(WEEKDAY(B9,2)=4,2,0)
 
How do I say the following
=IF(TEXT(B8,"ddd")="Thu",2,0)

or

=IF(WEEKDAY(B9,2)=4,2,0)
Click to expand...

I'm surprised you didn't offer these alternatives...

=2*(TEXT(B9,"ddd")="Thu")

=2*(WEEKDAY(B9,2)=4)

<g>

Why, by the way, did you opt to use the 2nd argument in the WEEKDAY function
call instead of the simpler single-argument form of this function?

Rick
 
...
....
Why, by the way, did you opt to use the 2nd argument in the WEEKDAY
function call instead of the simpler single-argument form of this
function?
Click to expand...

Because the OP has a UK e-mail address, and I'm not sure anyone
outside the US thinks of Sunday as the 1st day of the week. That is, I
was guessing the OP would find it more obvious to think of Thursday as
the 4th day of the week.
 
Because the OP has a UK e-mail address, and I'm not sure anyone
outside the US thinks of Sunday as the 1st day of the week. That is, I
was guessing the OP would find it more obvious to think of Thursday as
the 4th day of the week.
Click to expand...


Don't know if that is true for UK, in Sweden the week starts with Monday,
another thing is that it is easier for instance to use as a criteria e.g.


=WEEKDAY(A1,2)<6

is simpler than

=AND(WEEKDAY(A1)>1,WEEKDAY(A1)<7)
 
Why, by the way, did you opt to use the 2nd argument in the WEEKDAY
Because the OP has a UK e-mail address, and I'm not sure anyone
outside the US thinks of Sunday as the 1st day of the week. That is, I
was guessing the OP would find it more obvious to think of Thursday as
the 4th day of the week.
Click to expand...

Ah! That is interesting. Not having an international background myself, it
never occurred to me that other countries might start their calendar week
with Monday instead of Sunday. That would probably be the explanation, then,
between the Sunday/Monday start of week options on those date functions
offering a start-of-week option... I just figured the option was there for
company workweek usage only, not for general calendar use. You learn
something new every day. Thanks Harlan.

Rick
 
You must log in or register to reply here.

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

Average with #DIV/0! 4
SUMIF with criteria "<>" & "=" 4
CountIf previous cell formula 0
Run Macro If Cell have "x" value 0
sun results of a vlookup across a range 3
nested datevalue if and statements 5
IF statement and text 5
Multiple Conditionals in MS Excel 2007 6

Back
Top