Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

NUMWEEK Function not ISO proof

Topic Labels: Formulas
965 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lopez_Kaufman_R
4 - Data Explorer
4 - Data Explorer

Hello,

I am having an issue with the NUMWEEK Function that returns me week 3 instead of week 2 (according to google) for the following dates 13/1/2021 and 12/1/2021.

What does it mean ? Am I doing something wrong ?

1 Reply 1

Unfortunately, it looks like Airtable does not support ISO for week numbering. You may want to request this as a feature request by emailing support@airtable.com. However, you can probably incorporate ISO week numbering into your system by writing your own custom JavaScript.