2 Replies Latest reply on Apr 26, 2013 10:31 PM by yomango

    Working week

    yomango

      Title

      Working week

      Post

           Hello, outhere. I'd like to get a calculation that gives me back the week of the month a person started working. For instance, a person who starts any day between 4/1/2013  and 4/5/2013, the calculation should give me '1" as the first week of the month (In this case April starts on a Monday). If the person starts 4/12/2013, the calculation must give me a '2". I've tried several calculations but I am not succedding. The result should be a number between '1' and '5' for any date. Thanks in advance for any help.