Custom Column Formula for Work Week in Power Query Editor

[Arich62585]

Hi All,

    I am able to get the Work Week results by using "=Date.WeekOfYear([My Data])". However i am tyring to figure out how can i get the Work Week to start on Sunday's at 6:00:00AM and end on Sunday's at 5:59:59AM.

Example:

If my data is "8/27/2023 5:59:00", i would like the results to be 34 (WW34)

and

If my data is "8/27/2023 6:01:00", i would like the results to be 35 (WW35)

I'm sorry if this is a simple task but i've trying to search and cant find anything on this type of case.

Thanks in advance.

[ThxAlot · Accepted solution]

Simple enough

[Arich62585]

@ThxAlot , This worked perfectly. Thank you so much.

Last question for learning purposes, does (0,6,0,0) represent (Days, Hours, Minutes, Seconds)?