Take 2 days off date if Saturday or Sunday

[CiaraCaryl]

Hi I have a table with dates that only show the last day of the month but I need the values in this table to show up in a visual that uses dates that only have weekdays in them. Essentially I just need to create a date column  that takes 2 days off the given date if the day of the week name is Saturday or Sunday. This is the formula I am using but its not working. Any help would be great! tHANKS!

Last Work Day = IF('Finance Budgets'[Day Name]="Saturday" || "Sunday", (DATEADD('Finance Budgets'[Budget Date], -2 , DAY)), 'Finance Budgets'[Budget Date])

[Greg_Deckler · Accepted solution]

@CiaraCaryl Try:

Last Work Day = IF('Finance Budgets'[Day Name]="Saturday" || "Sunday", ( 'Finance Budgets'[Budget Date] -2 ) * 1., 'Finance Budgets'[Budget Date])