Count Days Between Two Dates

[Capsaicin Burn]

I thought this would be simple but my attempts are not working for me. I need two things PLEASE.

I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally clueless on the Week Day formula.

I am using Office 365

I have:
A1 = Start Date
B1 = End Date
C1 = Total Days Results
D1 = Week Days Results

I have tried several formulas.
I tried =DATEDIF(A1,B1,"d") also tried switching the A1 and B1.
I tried =DAYS(A1,B1) also switching A1 and B1.
Then I tried =DATEDIF(A1,B1,C1) with adding an additional column with simply a D in C1.

None of these work for me. All of them result in #VALUE !

Any help would be greatly appreciated!

Jim

 

[Capsaicin Burn]

That is outstanding information. I did as you asked and it was very enlightening. The value doesn't match the data validation restrictions. This will come in very handy. Thank you very much for your time. I really appreciate it!

 

[Joe4]

You are welcome.
Glad I was able to help!