IF statement

[babymoon]

I'm looking for an IF statement that solves this problem:

IF(weekday=Saturday,blank,actual day),IF(weekday=Sunday,blank,actual day)

the formula I'm using is: =IF(A2=$L$2,"",B2),IF(A2=$L$3,"",B2) where A2 is the weekday, L2 is the cell that says Saturday, L3 says Sunday, B2 is the actual date

keeps returning #VALUE

 

[Aladin Akyurek]

I'm looking for an IF statement that solves this problem:

IF(weekday=Saturday,blank,actual day),IF(weekday=Sunday,blank,actual day)

the formula I'm using is: =IF(A2=$L$2,"",B2),IF(A2=$L$3,"",B2) where A2 is the weekday, L2 is the cell that says Saturday, L3 says Sunday, B2 is the actual date

keeps returning #VALUE

Is this...

=IF(OR($L$2=A2,$L$3=A2),"",B2)

what you are after? If not, please elaboarate a bit more and post the value that you have in A2.

 

[T. Valko]

I'm looking for an IF statement that solves this problem:

IF(weekday=Saturday,blank,actual day),IF(weekday=Sunday,blank,actual day)

the formula I'm using is: =IF(A2=$L$2,"",B2),IF(A2=$L$3,"",B2) where A2 is the weekday, L2 is the cell that says Saturday, L3 says Sunday, B2 is the actual date

keeps returning #VALUE

Here's one way to write that formula...

=IF(OR(A2=$L$2,A2=$L$3),"",B2)

 

[babymoon]

THANK YOU! I couldn't for the life of figure this one out, lol

 

[GK039]

=IF(OR(WEEKDAY(B1)=1,WEEKDAY(B1)=7),"Weekend","Weekdays")

Takes the date value of the cell that houses your date and returns weekday or weekend. Change Weekdays with the actual day and Weekend with ""

George

I'm looking for an IF statement that solves this problem:

IF(weekday=Saturday,blank,actual day),IF(weekday=Sunday,blank,actual day)

the formula I'm using is: =IF(A2=$L$2,"",B2),IF(A2=$L$3,"",B2) where A2 is the weekday, L2 is the cell that says Saturday, L3 says Sunday, B2 is the actual date

keeps returning #VALUE