I need to apply an if formula, that is sensitive to the weekday of a certain event.
So, my ideia was to have =Weekday(A5,1) wich in my case gives me the exact weekday of the date on cell A5, and then apply an IF formula that would see if the result is a specific value...Monday or whatever.
The problem is that I always get a NAME error in the IF formula... =IF(S5="monday",Y,N) for example...S5 being the cell with the previous formula. I also tried with =IF(S5=monday,Y,N).... Tried changing the format of S5 to Numbers which would give me 1 , and change the formula accordingly, but nothing...
My guess is that even though we might see monday or 1 in cell S5, Excel sees something else, that is why my IF formula does not work I guess.