Feb 05 2024 11:09 AM
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!
Feb 05 2024 12:11 PM
@Mo_LVE
With a ship date in D2, enter the following formula in for example E2:
=WORKDAY(D2, -3)