+ Reply to Thread
Results 1 to 4 of 4

Convert date to weekday or weekend

  1. #1
    Registered User
    Join Date
    04-27-2017
    Location
    New York
    MS-Off Ver
    MS 365 v2211
    Posts
    85

    Convert date to weekday or weekend

    Hello,

    Is there a way to take a long column of dates and create a second column to indicate if each date was a weekday or weekend? The exact days of the week can be included if it's easier, but what really matters is binary: weekday or weekend.

    For example:

    5/7/17 Sa-Su
    5/8/17 M-F
    5/9/17 M-F
    5/10/17 M-F
    5/11/17 M-F
    5/12/17 M-F
    5/13/17 Sa-Su


    Thank you,
    Rook

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Convert date to weekday or weekend

    Try...
    =IF(WEEKDAY(A2,2)>5,"Sa-Su","M-F")

    EDIT:
    If you want the actual weekday.
    =TEXT(A2, "dddd")

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Convert date to weekday or weekend

    Try this.

    =IF(WEEKDAY(A1,2)>5, "Sa-Su", "M-F")
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    04-27-2017
    Location
    New York
    MS-Off Ver
    MS 365 v2211
    Posts
    85

    Re: Convert date to weekday or weekend

    Thank you both for assisting so quickly. Will update post as [SOLVED]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Have VBA Identify if it is a weekend or weekday
    By jdoerr1021 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-17-2016, 06:37 PM
  2. [SOLVED] Weekday/Weekend count from table
    By Mechanical Pencil in forum Excel General
    Replies: 3
    Last Post: 02-13-2016, 02:20 PM
  3. Average Last 7 Days by Weekday/Weekend
    By cleone1387 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-28-2014, 01:32 PM
  4. [SOLVED] Calculate Overtime Weekday different from Weekend
    By Lg101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2014, 04:41 PM
  5. [SOLVED] COUNTIFS dependent on date being on weekday or weekend
    By weldo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 04:09 PM
  6. [SOLVED] help please to identify and display 'WEEKDAY' or 'WEEKEND'
    By vin1602 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2013, 06:30 AM
  7. [SOLVED] Extracting data depending on whether a date is a weekday or weekend
    By weldo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2012, 11:24 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1