Date EndOfWeek Returns Saturday Instead of Sunday

[wsnyder]

Hi all,

Using Excel M365 Beta.

I entered 1/1/2022 into a cell and import into PQ
I added a custom column and entered the formula:

Date.EndOfWeek(#date(Date.Year([Column1]),
Date.Month([Column1]),
Date.Day([Column1])),Day.Sunday)

But it is returning 1/1/2022.
But I expect 1/2/2022.

1/1/2022 was Saturday
1/2/2022 was Sunday

What am I doing wrong?

Thanks
-w

 

[wsnyder]

Got it.
I thought the argument was calling for the last day of the week, but it is asking for the first day of the week so Day.Monday
Work great.

Here is the final PQ Formula I entered for the Custom Column

Date.EndOfWeek(#date(Date.Year([Column1]),
Date.Month([Column1]),
Date.Day([Column1])),Day.Monday)

Thanks
-w