Deduce Week Number (of 52) from Date Field

Hi Everyone

Does any one know of a formula that could deduce the Week Number in the Year from a given date field?

Any help would be greatly appreciated.


Screenshot 2022-04-01 at 16.08.03

Airtable has a WeekNum function that will allow for you to create week numbers. You create a column and make the field type formula and put the formula below.

Ex. WEEKNUM(Enquiry Date/Time)

1 Like

Lina, you’re an Angel. I’ll give this a shot when I’m back at a computer. Much appreciated.

Worked brilliantly. Exactly what I needed. Thanks again.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.