Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Deduce Week Number (of 52) from Date Field

Topic Labels: Formulas
Solved
Jump to Solution
1474 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Screenshot 2022-04-01 at 16.08.03

1 Solution

Accepted Solutions

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)

See Solution in Thread

3 Replies 3

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.