Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Apr 15, 2021 04:42 AM
I’m borrowing a formula from the ‘Ultimate Meal Planner’ by Kamile Parks… it works, except for the issue where Airtable goes by the American format of Sunday being the start of the week - I’m in Aus and go by Monday being the start.
IF(DATETIME_FORMAT(Date,‘gg ww’) = DATETIME_FORMAT(TODAY(),‘gg ww’),‘This Week’,IF(IS_BEFORE(Date, TODAY()),‘Elapsed’,‘Upcoming’))
Is there a way to make it count the Sunday as the last day of the week?
Apr 15, 2021 05:07 AM
I found a different solution and wanted to share if anyone else has a similar issue. Through some further digging I found out you can specify the starting day of the week when using WEEKNUM so I used the following formula:
IF(WEEKNUM({Date},‘Monday’) = WEEKNUM(TODAY(),‘Monday’), ‘This Week’, ‘Not’)