+ Reply to Thread
Results 1 to 2 of 2

Get Day of week based on other cells partial date

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    22

    Get Day of week based on other cells partial date

    Hello,

    I would like to know how to get the day of week based on inputs from the day number, Month (in cell L3) and Year (in cell L2)?

    2021-05-10_11-19-57.png
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,768

    Re: Get Day of week based on other cells partial date

    Try

    =WEEKDAY(DATE($L$2,MONTH($L$3 & 0),B3),2)

    2 gives Monday to Sunday
    1 gives Sunday to Monday

    Actual days ...


    =LOOKUP(WEEKDAY(DATE($L$2,MONTH($L$3 & 0),B3),2),{1,2,3,4,5,6,7},{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"})
    Last edited by JohnTopley; 05-10-2021 at 12:09 PM.

+ 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. Replies: 1
    Last Post: 02-04-2021, 03:28 AM
  2. Last Modified date of a file based on partial name
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2019, 12:49 PM
  3. sum week to date values based on todays date
    By nicko54 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-19-2013, 07:48 PM
  4. Summarizing partial data based on date range
    By Carol Salcido in forum Excel General
    Replies: 2
    Last Post: 03-12-2012, 07:34 PM
  5. week start date and end date based on week number
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 12:39 PM
  6. [SOLVED] Finding the Monday date based on a different date in same week
    By dandiehl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2006, 01:10 PM
  7. [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 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