Hi,
Looking for some help please ...
I'm trying to calculate week numbers for specfic dates (DD/MM/YYYY format) and the WEEKNUM calculation is not returning accurate results. I am trying to calculate the week numbers based on 1st Jan 2014 being in Week 01.
The formula that I am using is as follows:
=WEEKNUM(A2)
The week number returned for some dates is correct, however, for a number of records this is being returned incorrectly as per the below:
<tbody>
</tbody>
Can anyone help and suggest how this can be corrected please? ...
Thanks in advance for any hints / suggestions.
Regards,
Jay
Looking for some help please ...
I'm trying to calculate week numbers for specfic dates (DD/MM/YYYY format) and the WEEKNUM calculation is not returning accurate results. I am trying to calculate the week numbers based on 1st Jan 2014 being in Week 01.
The formula that I am using is as follows:
=WEEKNUM(A2)
The week number returned for some dates is correct, however, for a number of records this is being returned incorrectly as per the below:
Date | Week Number (With formula) | Correct Week Number |
12/01/2014 | 3 | 2 |
11/01/2014 | 2 | 2 |
10/01/2014 | 2 | 2 |
09/01/2014 | 2 | 2 |
08/01/2014 | 2 | 2 |
07/01/2014 | 2 | 2 |
06/01/2014 | 2 | 2 |
05/01/2014 | 2 | 1 |
04/01/2014 | 1 | 1 |
03/01/2014 | 1 | 1 |
03/01/2014 | 1 | 1 |
02/01/2014 | 1 | 1 |
01/01/2014 | 1 | 1 |
<tbody>
</tbody>
Can anyone help and suggest how this can be corrected please? ...
Thanks in advance for any hints / suggestions.
Regards,
Jay