ISO 8601 Week Numbers

ISO 8601 defines the Week as always starting with Monday being Day 1 and finishing with Sunday being Day 7. Therefore, the days of a single ISO Week can be in two different Calendar Years; and, because a Calendar Year has one or two more than 52

CalendarWeekISO8601.zip

I am not getting into the Excel formula, but it seems to me that "the first week which is mostly within the Calendar year" is equivalent to "the first week that contains four or more days of that year".

Hence WeekOfYearFiscal ( date ; 2 ) should be it.

Thank you comment. It is really that easy in FileMaker!

Thank you comment. It is really that easy in FileMaker!

Thank you comment. It is really that easy in FileMaker!

How do you calculate the last day of the iso week (i.e. Sunday)

or display the date range of the week?

ie, week 2 of 2016 needs to display 11th to 17th January 2016?

 

26 minutes ago, Patrick ONeill said:

week 2 of 2016 needs to display 11th to 17th January 2016?

What will be your input to this calculation? Will it be the two numbers, 2 and 2016 - or will it be a date in the given week?

 

Could it calculated it from the result of this calculation

WeekOfYearFiscal ( date ; 2 )

i am submitting to my clients a weekly time sheet and need to display the ISO week and either the day the week finishes or the date range of that week,

a later development would be to find the records based on the ISO week, Year, and Company.

9 minutes ago, Patrick ONeill said:

Could it calculated it from the result of this calculation

WeekOfYearFiscal ( date ; 2 )

It can be calculated directly from the date itself:

Let ( [
mon = date - DayOfWeek ( date - 1 ) + 1
] ;
mon & ".." & mon + 6
)

 

 

thanks for the help, worked a treat