Formula to filter dates to only show last week

Question

I have a team that wants to send a weekly digest that shows updates only from the previous week. I found a formula that can show if a date is this week or not but can't figure out a way to show just dates from the previous week

Sho · Accepted Answer

For example, this formula could display "previous week" if the date was previous week.

IF(
  {Date},
  IF(
    DATETIME_FORMAT(DATEADD(NOW(),-1,"weeks"),"w")=DATETIME_FORMAT({Date},"w"),
    "previous week"
  )
)

Thank you so much! I was absolutely overthinking it and this is much more straight forward.

Kelly_Vorrasi1 · Answer

For example, this formula could display "previous week" if the date was previous week.

IF(
  {Date},
  IF(
    DATETIME_FORMAT(DATEADD(NOW(),-1,"weeks"),"w")=DATETIME_FORMAT({Date},"w"),
    "previous week"
  )
)

Thank you so much! I was absolutely overthinking it and this is much more straight forward.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded