Results 1 to 17 of 17

Returning Week # per Month based on Date

Threaded View

  1. #1
    Forum Contributor 00Able's Avatar
    Join Date
    11-17-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    244

    Returning Week # per Month based on Date

    Based on the Date/Month/Year, I want to return the week number the date is.


    If cell a1 = 1/1/2012 then in b1 I want to return 1 (as it is in the 1st week of the month)
    If cell a1 = 2/6/2012 then in b1 I want to return 2 (as it is in the 2nd week of the month)
    If cell a1 = 1/31/2012 then in b1 I want to return 5 (as it is the 5th week of the month)
    If cell a1 = 2/1/2012 then in b1 I want to return 1 (as it is in the 1st week of the month)

    I have tried different versions of WeekNum formula but that isn't working, any ideas?

    Any ideas?
    Last edited by 00Able; 02-02-2012 at 06:53 PM.
    Providing Problems for Your Solutions
    STARS are my Punching Bag, You will be rewarded.

    In the rare event that I may help you, feel free to make me see STARS

Thread Information

Users Browsing this Thread

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

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