NETWORKDAYS function minus 1 day

[oniete1997]

Hello,

I am currently working on a project that requires me to get the total number of business days between two dates. I have used the NETWORKDAYS function and it works great. However, I need a formula (if their is one) that will give me the total number of business days between the dates and either A) minus 1 from the total or B) not include the first day as an actual work day.

example.

Start date - 3/20/12
End date - 3/23/12
Total number of business days minus 1 = 3

I can do this if i use the function, copy and paste special and then create another row next to the total and do a =A1-1 all the way down but was just wondering if their was an easier way.

Any help with this would be much appreciated.

[icestationzbra]

if Start Date is in A1 and End Date is in B1, put in another cell:

=NETWORKDAYS(A1,B1)-1

is that what you are looking for?

[darknation144]

If you have received a satisfactory solution please mark this post as solved.

[oniete1997]

This did work, I thought I tried this before and it didn't work but I may have put the -1 inside of the (). Thank you so much for the quick help!