Back Dating Formula

Copper Contributor

I have a ship date, but want to automate a field to show the date that is three business days before the ship date.  Sounds like it should be a simple formula, but I cannot figure it out!  HELP!

 

1 Reply

@Mo_LVE 

With a ship date in D2, enter the following formula in for example E2:

 

=WORKDAY(D2, -3)