#### Capsaicin Burn

##### New Member

- Joined
- Jan 26, 2018

- Messages
- 38

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