Week numbers in a chart | Airtable Community

How do I revise this formula so that it gives me both the week # and the range of days in that week?

DATETIME_FORMAT({Date to work on it},‘ww’)

Also, is there a week to do a week number that doesn’t start over at the beginning of the year?

All I really want to do is be able to create either a chart or a pivot table that gives me the sum of an integer weekly over about eight weeks.

Thanks!

Page 1 / 1

Hi Tobin, any chance you could provide some example data and the desired output?

Thanks Adam, I was actually able to get it to work. Thanks for the response though.

Would you mind sharing your solution for other community members who might be faced with the same problem?

Sign up