derek davis
Member
Hello guys, I am attempting to display via a TEXT function in cell B5 the day name according to the date contained within A5, now this works fine. Taking this a step further I would like to display two day names when the condtion in C5 = "cool". I am unsure how to tackle this issue. Could I ask for some advise please.
When C5="cool" B5 should display "Sun/Mon" at present I am getting an Error.
I have attached a sample sheet for viewing. Any assistance would be appreciated. I had posted this question on a different site but did not recieve any active reply.
Thanks everyone.
When C5="cool" B5 should display "Sun/Mon" at present I am getting an Error.
I have attached a sample sheet for viewing. Any assistance would be appreciated. I had posted this question on a different site but did not recieve any active reply.
Thanks everyone.