I need formula for " if a3 is sunday tues than smith . if a3 is monday wednesday friday saturday than walker"
Thank you
I need formula for " if a3 is sunday tues than smith . if a3 is monday wednesday friday saturday than walker"
Thank you
=IF(OR(WEEKDAY(A3)=1,WEEKDAY(A3)=3),"smith","walker")
Ben Van Johnson
I think what Ben gave you would work if you have dates in col A formatted as days of the week.
assuming you simply have days in col A such as Sunday etc, then maybe this...
=IF(OR(A3="Sunday",A3="Tuesday"),"smith",IF(A3="Thursday","","walker"))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
The formula goes where ever you want the results.
You didn't say what's in A3. I assumed it was a date. That's why you should always attach a sample file to preclude guesswork.
2 options:
=IF(OR(S6="Sunday",S6="Monday",S6="Tuesday",S6="Wednesday",S6="Saturday"),"smith","walker")
=IF(OR(S6="Thursday",S6="Friday"),"walker","smith")
Quang PT
Works thank you Guys for help
Last edited by bobeknr1; 04-19-2021 at 12:39 AM.
Look at post #3.
Yes check week day as a number not as a name (text)..
It would help immensely if you attached a workbook so we can see exactly what you are working with and give a solution. Attach a workbook as described in the yellow banner at the top of the page.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks