Formula to list date range

Topic Labels: Formulas
529 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
4 - Data Explorer
4 - Data Explorer

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