LastDayOfPeriod(Date date, Duration period, Date reference)
Returns the last day of the period in which the given date falls.
- The date for which to calculate the last day of the period.
- The duration representing the cycle of periods.
- The starting date of the sequence.
The cycle of periods is defined by the given period duration, repeated in sequence starting from the provided reference date. If the period is not a whole number of days, the fractional part is ignored.
LastDayOfPeriod(Today(), Days(7), Date(2006,1,1)) finds the last day of this week assuming the week starts on Sunday, since 1/1/2006 is Sunday.
For weeks starting on Monday, you can use 1/1/2007 as the reference, for example:
LastDayOfPeriod(Today(), Days(7), Date(2007,1,1))