Is there a way to make Friday - Sunday show as weekend?

I'm trying to find a way to show Friday through Sunday as a weekend. I have a timestamp that says "First Shift" and "Third Shift" in another cell but I can't find a way to make it say "Weekend" on Friday through Sunday. I even have the date stamp formatted to text hoping I could use the words "Friday-Sunday" to do an IF THEN Statement but with no luck.

**Wanting the ending row that says "First Shift" "Third Shift" to say "Weekends" if it lands on Friday-Sunday. If thats clear enough.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Originally Posted by crowmagnus

Sorry about that, I forgot to hit "Upload" the first time.

Thanks, but there is no data in the workbook

Please manually enter a representative sample of your data and the results you expect, and tell us which are the results and which the data, along with a note of the calculations you have used.