Skip to main content

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


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)

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)


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

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)


Worked brilliantly. Exactly what I needed. Thanks again.

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)


Thank you for that Lina!

Reply


Terms & Conditions