Networkdays Issue

[Harbor1704]

Hi Everyone,
I have not found a simple solution and the ones I found seem to be a little different than what I am looking for. I am trying to calculate the days without holidays and weekends between two dates. On my sheet I have todays date as =Today() as C2 then I put in the date task was started (C22). When I put in the start date as a Friday and the current date is a Monday I get 2 days. All the formulas I keep seeing are complex if formulas to fix this. Is there a simple formula to use that will show only 1 day between the two dates; and if the start date is the same as the current date it will show 0? Right now I have to manually update the days everyday.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=NETWORKDAYS(C22,C$2)-1

 

[Harbor1704]

Thank you, I put that in and for some reason it gave me this :

Saturday, January 0, 1900

 

[Fluff]

Change the format of the cell to General.

 

[Harbor1704]

Thank you!!! works amazing!

 

[Fluff]

You're welcome & thanks for the feedback.