WeekOfYear ISO 8601

This topic is 2621 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Share on other sites

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.

Share on other sites

• 2 weeks later...

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

Share on other sites

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

Share on other sites

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

Share on other sites

• 10 years later...
• Newbies

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?

Share on other sites

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?

Share on other sites

• Newbies

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.

Share on other sites

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
)```

• 1
Share on other sites

• Newbies

thanks for the help, worked a treat

Share on other sites

This topic is 2621 days old. Please don't post here. Open a new topic instead.

Create an account

Register a new account