Calculating week-of-year for a date

Showcase
22

Hi @Xiphware
I am new to the ODK forum. I think the xls is perfect and works well for a normal calendar year.

I have tried to change this based on your xls (above) to accomodate fiscal year but unable to get the correct results, where the fiscal year starts on 1 October and ends on 30 Sep each year.

Can you please assist. Your help will be much appreaciated.

23

That will be somewhat dependent on what your definition is of a 'fiscal year week'... eg is October 1 defined as week 0 vs week 1? Further, is, say, Oct 3 always in the same 'fiscal week' as October 1, or does it depend of what actual day-of week it happens to be relative to October 1? eg say Oct 1 is Saturday; is Monday October 3 in the same fiscal week or the next one? And what if October 1 is Sunday? etc.

24

Hi @Xiphware

Thank you for your response

  • The start of October 1 would be defined as week 1
  • Sunday would be the start of any fiscal week.
  • Oct 3 will always be dependent on what actual day of week it happens to be relative to October 1
    I think in some years there will be 53 weeks.

Based on your above technical questions that is all info i can provide.

Hope this info helps.