I have a date field in my table named “Date Paid”. I would like to determine the week number of the month that date falls into in another field. Example, 2017-11-01 falls into week one of November, 2017-11-06 falls into week 2. Is there a formula that will do this? I know in VBA I can write a function to do this but want to do this in Airtable.
I’ve been able to determine the month “Date Paid” falls under pretty easily with,
but don’t see any built in functions for week number of the month
Thanks for any tips you can provide for this!