Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Include Sunday in formula to determine if current week

Topic Labels: Formulas
1204 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah_Chilby
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1
Sarah_Chilby
5 - Automation Enthusiast
5 - Automation Enthusiast

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’)