I have a column (say A) of days of the week and I need an adjacent column to display whether each day is weekday (Mon, Tue,Wed,thurs,Fri) or Weekend (Sat or Sun). can anyone plase help? Thanks
I have a column (say A) of days of the week and I need an adjacent column to display whether each day is weekday (Mon, Tue,Wed,thurs,Fri) or Weekend (Sat or Sun). can anyone plase help? Thanks
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
What to you mean? Can you explain this a little more? Have you a number and you want to see which day is this?...I have a column (say A) of days of the week ...
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this in B2:
=IF(WEEKDAY(A2,2)>5,"Weekend","weekday")
then copy down.
Hope this helps.
Pete
Please try this logic.
Please click 'Add reputation', if my answer helped you.
Pete - thanks for your reply but my column A contains days as text (not as numbers 1-=7) and your formula gives no value when I copy this into B. Any suggestions
Apologies - your formula works when I use the DATE (eg 01/09/2013) and not the text (eg SUNDAY).
Last edited by vin1602; 09-06-2013 at 06:08 AM.
Try this then:
=IF(LEFT(A2)="S","Weekend","weekday")
Hope this helps.
Pete
Perfect - many thanks for helping this novice!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks