Results 1 to 3 of 3

Thread: Nth Day Of Week Number Using Formula

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    12

    Nth Day Of Week Number Using Formula

    What formula do I require to achieve the following
    Week number
    Date sequence
    Thanks
    Paul
    Excel 2013
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Dec 2012
    Posts
    6
    Rep Power
    0
    Try these:

    If the weeknumber is in A1, then:

    =DATE(2013,1,A1*7-2)-WEEKDAY(DATE(2013,1,3)) for Monday
    =DATE(2013,1,A1*7-2)-WEEKDAY(DATE(2013,1,3)) + 2 for Wednesday
    =DATE(2013,1,A1*7-2)-WEEKDAY(DATE(2013,1,3)) + 4 for Friday

  3. #3
    Junior Member
    Join Date
    Apr 2011
    Posts
    6
    Rep Power
    0
    You dates are not valid Excel dates - they are are text.

    See if this is what you wanted. It assumes your data is consistently in the format show (3-character day followed by date)

    =WEEKDAY(MID(D4,5,LEN(D4)-4)+0)

Similar Threads

  1. Nth Such-And-Such Day Of The Month
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 01-02-2020, 06:48 PM
  2. Data Validation For Selecting Date And Week Number
    By paul_pearson in forum Excel Help
    Replies: 8
    Last Post: 06-16-2013, 05:07 AM
  3. Replies: 17
    Last Post: 12-18-2012, 04:15 PM
  4. Nth Working Day Including Saturday
    By Excel Fox in forum Download Center
    Replies: 0
    Last Post: 10-10-2012, 02:41 AM
  5. Week Number And Week Start Day of Week
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 10-24-2011, 07:33 PM

Posting Permissions

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