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
Solved
Deduce Week Number (of 52) from Date Field
+8Best answer by Lina_Clark
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)
+1Airtable 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)
+8Airtable 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.
+8Airtable 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.
+2Airtable 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!
+1how to define the week start day, like if I would like to start my week from Mon instead of Sun. With the current formula, it strats the week from Sun - which is by default same a excel. But in excel we can define the week start day by putting number. For example: we define by “2” to start the week from Mon.
+28Hey
I might be getting this one wrong, but wouldn’t the following formula help?
DATETIME_FORMAT(DATEADD({Your Date}, -1, 'days'), 'W')
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.