Results 1 to 6 of 6

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

Threaded View

  1. 03-26-2022, 05:56 PM #1
    crowmagnus
    crowmagnus is offline
    Registered User
    Join Date
    06-12-2012
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010, 2016, 2021-22
    Posts
    87

    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.
    Attached Files Attached Files
    Last edited by crowmagnus; 03-26-2022 at 06:14 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Return next Sunday's date beginning this Friday.
    By josephdemars in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2015, 02:13 PM
  2. [SOLVED] Transforming weekend date to previous Friday
    By RaydenUK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2015, 03:57 PM
  3. [SOLVED] Dates in Excel - If Saturday or Sunday, return Friday's date
    By gjrr4x1 in forum Excel General
    Replies: 6
    Last Post: 02-12-2015, 02:56 PM
  4. Formula to adjust a weekend date to the previous Friday...
    By joencrystal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2013, 05:25 PM
  5. Change Weekend Date To The Previous Friday
    By MarkMcCann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2012, 09:45 AM
  6. change background color if weekend (saturday and sunday)
    By alexandruc in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-29-2009, 03:20 AM
  7. How do I set NETWORKDAYS to regard friday and saturday as weekend
    By Shay.C. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2006, 03:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1