Forum Discussion

RajHelaiya's avatar
RajHelaiya
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
------------------------------
  • 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: https://data.quickbase.com/db/bqeqqj33i

    ------------------------------
    - Sam

    ______________________________________________
    Sam Jones
    Vice President, Product and Technology
    he/him

    The Data Collaborative, Inc.
    sjones@datacollaborative.com
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
    ------------------------------