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