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


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


=WORKDAY(D2, -3)