Formula to list date range

Hey community,

I am decently new to Airtable and am excited to get to know it better, but I am stumped on creating this formula. I’ve beeI have been trying to output the range of a number of days within a week when given the first day of that specific week.

I need it to be formatted with the month like, “June 21-27” in it’s column.

What I have is…

DATETIME_FORMAT({Start Date}, ‘MMMM DD’) & “-” & DATETIME_FORMAT((DATEADD({Start Date}, 6, ‘days’), ‘DD’)

I keep getting error messages like:

Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

I’ve been messing around with it quite a bit, but can’t seem to produce what I want. I am sure there is a solution to this simple formatting problem. Is there a way to do this using the “Date” field type? Or maybe I can only use DATE_FORMAT() once per line.

Never mind, I just avoided this problem by creating another column that is the “End Date”, and formatting that in instead of adding to the “Start Date”.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.