I am using a pre-made excel spreadsheet for time sheets at work. I work 32 hours a week with Monday off. I am trying to insert an IF function that if the Day is 'Monday', return 'Non-Work Day'.
I am currently using:
=IF(B12="Monday","Non-Work Day," ")
however all i get is a blank cell, even if the day is Monday.
I believe the problem is : the date column sets the day, so 1 July 2019 in cell C11 automatically changes the day in cell B11 to Monday, so the value in B11 is still equal to 1 July 2019, not Monday. (formula in B11 is '=c11)
Is there a way to get excel to read the output of 'Monday' instead of the input of '=c11' so I can match to 'Monday'?