Deduce Week Number (of 52) from Date Field

[Stephen]

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.

Stephen

[Lina_Clark · Accepted solution]

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)

[Stephen]

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

[Stephen]

Worked brilliantly. Exactly what I needed. Thanks again.

[Johanka_2014]

Thank you for that Lina!