Forum Discussion

RajHelaiya's avatar
Qrew Captain
5 years ago

Date formula - Return Sunday for every week

I have a formula Date field called Week end date. 
I need to set it to Sunday of the current week. 

For example if today is wednesday 5/20/2020 the week end date should be set to 5/23/2020. It needs to calculate from date created field. 
If this is not possible can I need to base it off from another date field, called week start date. A user selects the start date and according to the selection the week end date should be the coming Sunday of the week start date. Can anyone help on the formula?

Raj Helaiya

1 Reply

  • Hey Raj,
    Sunday this week is the 24th, right? If that's the case, then this formula works.

    NextDayOfWeek(ToDate([Date Created]), 0)​

    Happy to help out more during Data Collaborative's free office hours, every Thursday at 1pm Eastern.
    Sign up here:

    - Sam

    Sam Jones
    Vice President, Product and Technology

    The Data Collaborative, Inc.
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474