Results 1 to 8 of 8

[SOLVED] Return month for weeknumber

Threaded View

Hawken [SOLVED] Return month for... 04-24-2013, 04:22 AM
martindwilson Re: Return month for... 04-24-2013, 06:38 AM
XOR LX Re: Return month for... 04-24-2013, 07:41 AM
Hawken Re: Return month for... 04-24-2013, 08:26 AM
daddylonglegs Re: Return month for... 04-24-2013, 09:07 AM
Hawken Re: Return month for... 04-24-2013, 09:32 AM
daddylonglegs Re: Return month for... 04-24-2013, 09:53 AM
Hawken Re: Return month for... 04-25-2013, 06:19 AM
  1. #1
    Registered User
    Join Date
    02-16-2010
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    12

    [SOLVED] Return month for weeknumber

    Hi. I have a sheet for registering work hours on projects. It is organized in months and weeks, and I want to be able to return the correct month for each weeknumber.

    The rules are:

    A week starts monday and ends sunday.
    If a week has days in two months, it should belong to the month with 3 or more workdays (monday - friday) in it.

    ex. week 18 in 2013 should return May.

    How can i do this?

    cheers

    Hawken
    Last edited by Hawken; 04-25-2013 at 06:19 AM.

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