AnsweredAssumed Answered

Working week

Question asked by yomango on Apr 26, 2013
Latest reply on Apr 26, 2013 by yomango


Working week


     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.