Week Number formula for fiscal year

Hi,
I've tried this formula but when I use it for past years, say 2014 the 9/7/2014 is resulting in week 3 for Wednesday the 9th July, when it should be week 2. Tuesday the 8th July is also resulting in week 3 - same as Wednesday when the start of the week is Wednesday. Am I doing something wrong?

To clarify I need each week to start on a Wednesday and finish on a Tuesday as this is our pay cycle. Financial years begins on 1st July and ends on 30 June.

=IF(((A3-DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1)+WEEKDAY(DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1),13))/7)-(INT((A3-DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1)+WEEKDAY(DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1),13))/7))=0,INT((A3-DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1)+WEEKDAY(DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1),13))/7),1+INT((A3-DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1)+WEEKDAY(DATE(IF(MONTH(A3)>=7,YEAR(A3),YEAR(A3)-1),7,1),13))/7))

The formula states day 13, which is Wednesday so I can't work out why it's not working.

Any help would be great.

Thanks

Hi Humdingaling,

Actually you are right.

Wednesday 25th June 2014 = Week 1
Wednesday 2nd July 2014 = Week 2.

Wednesday 29th June 2016 = Week 1
Wednesday 6th July 2016 = Week 2

Fantastic! Thank you! It works perfectly.