Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to: get next monday based on creation date

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

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

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.