I have a formula where I am trying to use WORKDAYS and it is adding an extra day to the outcome (it is counting the start date). For example, I am trying to figure out how many working days a study is in Unassigned before it gets to Assigned. I also want the cell to show blank if Assigned date is not entered. How can I get it to subtract a 1. I tried adding a -1 at the end and it does not work.
Formula: IF({Date Assigned}=“”,“”,WORKDAYS({Date Assigned},{Date Unassigned}))