+ Reply to Thread
Results 1 to 4 of 4

Choose and Weekday Function

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Choose and Weekday Function

    I am trying to create a CHOOSE and WEEKDAY Function.

    I have successfully created the weekend column but I wasn't able to get the right function for weekday part.

    What I want is to start the week every Monday. For example, any date from period April 21-25 should start April 21.

    I attached the workbook Weekday for your reference. Thanks for the help!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Choose and Weekday Function

    Try:
    =A2-MOD(WEEKDAY(A2,3),7)

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Re: Choose and Weekday Function

    Thank you so much, ragulduy!!! Can you please explain how does it work or the logic? Please bear with me I am just a newbie to excel formula and functions.

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Choose and Weekday Function

    The Weekday function returns the weekday of a date (as you know), the second arguement, which I have set to 3, means that Tuesday will be a "1". The mod function returns the remainder if you divide the first number by the second, although now that I think about it, that bit is redundant. You can just use:
    =A2-WEEKDAY(A2,3)

+ 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] Using CHOOSE and WEEKDAY to Display Wednesday and Saturday Dates With Time
    By wtierce in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-25-2013, 11:34 AM
  2. Replies: 14
    Last Post: 07-24-2013, 06:08 PM
  3. Weekday function into VBA
    By Libster78 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2010, 07:20 AM
  4. Weekday function +1 day
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2009, 12:42 PM
  5. [SOLVED] Weekday Function
    By John in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2005, 08:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1