Hello everybody!
I have dates in my table, I calculated them to find out which weekday is it.
Now, I need formula that will give me the result :Workday or Weekend.
I started with:
=WEEKDAY(A2,1)
=CHOOSE(WEEKDAY(B2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
=IF(B2=2,"Workday","Weekend")
and I don't know how to proceed with other days.
I know that I need OR function, but don't remember how to use them together.
Thank you for your help!
hi nelkin, welcome to the forum. you can actually shorten that to:
=TEXT(A2,"dddd")
assuming your weekends are sat & sun, then:
=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank You so much!!!
You saved me a lot of time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks