IF and Date
Well, what I've figured out is that Friday and Monday are the days that will
say "OFF"
Im using Jacobs passed on suggestion like this:
=IF(WEEKDAY(A8)=2,"OFF","")
But what I need is it to do the same if the day is 6 as well...
Something like this:
=IF(WEEKDAY(A8)=2)or(Weekday(A8)=6),"OFF","")
But this isn't working
Any ideas Valko?
|