Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to calculate a repeating date - i.e. 2nd Thursday of the month?

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

Hello, How would I calculate a repeating date?

For example the next second Thursday of the month?

Cheers

1 Reply 1

Hi @Stephen_Reid

Welcome to Airtable Community !

Im not sure where you exactly want to add it. But you can use the formula DATEADD(date, 28, ‘days’) to calculate this date from another Thursday. (the is in case you have another date in another field that is actually a 2nd Thursday of the month).

If for example you want to add this in one field without another field having the date, you can do the following:

  1. Create a field and call it sequence, make it as Autonumber.

  2. Use this formula

DATEADD(DATETIME_PARSE("12 Mar 2020", 'D MMM YYYY'), sequence*28, 'days')

Hope this helps