Results 1 to 5 of 5

Thread: Week Number And Week Start Day of Week

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-24-2011, 06:49 PM #1
    Excel Fox
    Excel Fox is offline
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    =C2-WEEKDAY(C2,2)+1
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook
    Reply With Quote Reply With Quote
  2. 10-24-2011, 07:33 PM #2
    Rajesh Kr Joshi
    Rajesh Kr Joshi is offline
    Member
    Join Date
    Aug 2011
    Posts
    92
    Rep Power
    15
    Simply awesome thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Nth Day Of Week Number Using Formula
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 06-16-2013, 06:40 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. VBA Trick of the Week :: Slicing an Array Without Loop - Application.Index
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-12-2013, 04:40 PM
  4. Code To Add Date And Seven Day Week Number From Start Of Year
    By rich_cirillo in forum Excel Help
    Replies: 17
    Last Post: 12-18-2012, 04:15 PM
  5. Week Of The Month
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 02-22-2012, 08:35 PM

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
  •  

Forum Rules