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 nee...
Forum Discussion
Hey Raj,
Sunday this week is the 24th, right? If that's the case, then this formula works.
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
------------------------------
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
------------------------------
