Literal based on Week end

  • Thread starter Thread starter Umar
  • Start date Start date
U

Umar

I tried these to NO avail:
Cell D51 contains a formula -> =TEXT(B51,"dddd")

For Cell E51 I want to enter an IF condition based upon the Weekday value in
Cell D51.

So, here is what I have tried and I also have tried some other variations:

1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged")

2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged')

All failed, could anyone pinpoint and corrected the typo?
 
=IF(OR(D51="Sunday",D51="Saturday"),"No Hours Recorded","Charged")

Remember to Click Yes, if this post helps!
 
As others have told you, your syntax for the OR was incorrect (it is a
function, not an operator); however, for your particular formula, you don't
need to use OR at all; here is an alternative...

=IF(WEEKDAY(B51,2)>5,"No Hours Recorded","Charged")

Note the argument for the WEEKDAY function is B51... your actual date, not
D51 which only contains the text for the day of the week... and that the 2
tells the WEEKDAY function to count the days of the week starting with
Monday; hence, Saturday would be day number 6 and Sunday would be day number
7, which is why the test I use is >5 (you could use >=6 if you wanted to)
 
Cell D51 contains a formula -> =TEXT(B51,"dddd")

Another one...

=IF(LEFT(D51)="S","No Hours Recorded","Charged")
 
Back
Top