Forum Discussion
Solved
If a cell contains specific text, return this specific text otherwise leave blank
Hi, 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...
Hi
The setup is not clear to me. However to evaluate the Weekday of any date you can use one of 2 functions:
- Weekday function >> Returns a number from 1-7 (or 0 to 6)
- TEXT function >> Returns text based upon the formatting you specify in the second argument.
In your case , if you are evaluating the date in cell B12, then your function will be
=IF(TEXT(B12,"dddd")="Monday","Non Working Day","")
Your other issue of a cell referencing a wrong one, I need to check and audit your worksheet to fix it.
Hope that Helps
Nabil Mourad
I was looking for a formula that would give me a similar result and came across this post. I changed the reference cell of B12, changed the "Monday" and the "non working day" to what I needed and it worked perfectly. Thanks for posting this. This is a great community.