Create new records for [Monday of the week of created time] - [Sunday of the week of created time]

Topic Labels: Formulas
262 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi Airtable community, first time posting here. Thanks for your help in advance.

So, I'm trying to create something like YC Startup School weekly update forms: every new record will be named as "[Monday of the week of {created time}] - [Sunday of the week of {created time}]". 

Just like this:
Screenshot 2023-08-18 at 7.13.18 PM.png

I'm very new to using formulas, but would really love to learn how that works.

Tried "Weekday", "Dateadd"


Got stuck right here. Thanks a lot!


0 Replies 0