Subtract 1 working day from Date Column

[NetBoulter]

I'm new so please bear with me. 

I have data coming in from csv (dumped from database so I don't want to do the calculation in the csv).

One of the columns is "Acknowledged" date. I need to calculate the "Delivery Due" date, which is the "Acknowledged" date less 1 working day. 

Obviously simple in Excel and will be simple for you experts but I am lost, have searched the e-learning and the community and can't find anything that I can work from. 

PS the reason I am not connecting direct do Database is that it is a bespoke one and I'll attack the how to do that at a later date!

Thanking you in advance

NetB

[Greg_Deckler · Accepted solution]

Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:

Delivery Due = [Acknowledged] - 1

[germanobasler]

Hello,

What if the number of days to subtract or add is variable, so there is a column to add or subtract, would it be as simple as [Date] + [Column with number of Days]?

BI simply does not accept this procedure.