Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula to list date range

Topic Labels: Formulas
238 1
Showing results for 
Search instead for 
Did you mean: 

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

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