Skip to main content

Include Sunday in formula to determine if current week

  • April 15, 2021
  • 1 reply
  • 13 views
S
Forum|alt.badge.img

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

S
Forum|alt.badge.img
  • Sarah_Chilby
  • Author
  • Participating Frequently
  • April 15, 2021

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

L
Terms & ConditionsAccessibility statement