Formula for next weekday relative to today


#1

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

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.


#3

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.