Help with start date

[#1]

My max Date is 03/03/2016.

I want to make the start of week as Sunday i.,e 02/28/2016

So I gave my expression as

=WeekStart(max(Date,0))

But it still returns start of week as 02/29/2016. Any help greatly appreciated.

[its_anandrjs · Accepted solution]

Did you try this

=Date(WeekStart(Today())-1)

Or

=Date(WeekStart(DateField)-1)

Regards

Anand

[johnw]

weekstart(Date,0,-1)

The third parameter is the offset from starting on Monday.