Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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)