With the current time, how to get the next week, the last day of the time?

With the current time, how to get the next week, the last day of the time?

Started by Kitty at February 07, 2016 - 7:42 AM

The first day of the week
(1)Sunday is the first day
RelativeDate( today(), 2 - 1 - (1 - sign(daynumber(today()) + 1 -1))*7 -DayNumber ( today() )
(2)Monday is the first day
RelativeDate( today(), 2 - 0 - (1 - sign(daynumber(today()) + 0 -1))*7 -DayNumber ( today() )

Next week is the last day, the first day of the week + 13 days

Posted by Harriet at February 16, 2016 - 7:48 AM

relativedate(today(),2 + daynumber(today()))

Posted by Kitty at March 02, 2016 - 8:01 AM

relativedate(today(),15 - daynumber(today()))

Posted by Harriet at March 08, 2016 - 8:09 AM

Posted by Uriah at December 17, 2016 - 5:54 AM

Posted by Noah at January 01, 2017 - 6:12 AM

Posted by Rudolf at January 01, 2017 - 7:03 AM

To the last day of the week there are a few days away from the current time, add 7 days can be.

Posted by Chester at January 02, 2017 - 7:39 AM

relativedate(today(),2 + daynumber(today()))

Posted by Warner at January 07, 2017 - 6:37 AM