Help

Formula for next weekday relative to today

1660 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Erika_Ortiz
4 - Data Explorer
4 - Data Explorer

I’m trying to figure out how to create a formula that will tell me the date for the next specific weekday. For example, if the meeting is on Wednesdays, then give me the date for the next Wednesday from today.

I’ll have a field that says Wednesday and another field where I can input the formula to spit out the date for the nearest Wednesday from today. Any ideas?

2 Replies 2
Alex_Wolfe
8 - Airtable Astronomer
8 - Airtable Astronomer

Made a quick demo base - let me know if this is what you are looking for; the only input is the first ‘Date’ field for the original meeting date.

Formulas are in the description of each field. Note this only adds 1 week to the ‘Date’ input based on your Wednesday - Wednesday example.

Ivan_Carlson
7 - App Architect
7 - App Architect

I tested it in Excel, Just substitute the Excel formula “WEEKDAY(A2,11)” with:

VALUE(DATETIME_FORMAT(Date,“E”))

where “A2” is your Date field in Airtable.

Untitled.png