Help

How to: get next monday based on creation date

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

Hi, we do weekly reporting through Airtable - but we would like to group the reports by the meeting date (every Monday).

Typically a record is submitted on Friday (can also be any other day), and we would like to set the ‘Meeting date’ automatically to the next Monday of the submission date. Now we have to add it manually.

Is there a way to use the Submission date option to fill in the next Monday in the ‘Meeting date’ column?

1 Reply 1
Matthew_Moran
7 - App Architect
7 - App Architect

Here is a formula that should work:
DATETIME_FORMAT(DATEADD({A date},8-WEEKDAY({A date}),“days”),“MM/DD/YYYY”)

Where {A date} is either the record created date or a date that is entered upon submission.