Skip to main content

How to: get next monday based on creation date

  • November 19, 2019
  • 1 reply
  • 2 views

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

Forum|alt.badge.img+11

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.


Reply