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.

Thank you for that Lina!

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

Hey ​@PA at bp,

I might be getting this one wrong, but wouldn’t the following formula help?

DATETIME_FORMAT(DATEADD({Your Date}, -1, 'days'), 'W')

 
Mike, Consultant @ Automatic Nation 
YouTube Channel

Hm, try WEEKNUM?  From the docs

 WEEKDAY(TODAY(), "Monday")