Formula challenge, with week to date

[shophoney]

Hi i'm trying to get a week to date(WTD). This is date -1

The problem is EXCEL starts the week on Sunday and I need it starting Monday. So I've built a helper cell to my table that subtracts a day. IE January 1/18 = December 31/17.

Everything works fine see formula below. Excel for the start of this year and how the dates fell. It doesnt show Monday in the WTD for the current week.

How can I fix it to pick up the correct dates for the week.

The formula below is from a powerpivot table.

=if( year(dCalendar[wtd])=year(today())&&weeknum(dCalendar[wtd])=WEEKNUM(today()-1)&& (dCalendar[wtd])<=TODAY()-1 ,"CURRENT WEEK","OTHER")

Thanks

 

[DRSteele]

If you read through the Help page for functions WEEKNUM and WEEKDAY, you will see that each has an argument that controls which day is the desired beginning of the week. See here for example: https://support.office.com/en-us/ar...pId=xlmain11.chm60513&ui=en-US&rs=en-US&ad=US