Forum Discussion
If a cell contains specific text, return this specific text otherwise leave blank
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
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
Thank you, that formula works.
That was my only issue, I must have explained my issue poorly, thank you for your help.
