How to Calculate No. of Days between two dates

[Guest]

In Column A, I have a list of dates. (MM/DD/YYYY)
In Column B, I have another list of dates. (MM/DD/YYYY)

What's the formula, in Column C, to determine the difference in the number
of days between Columns A and B?

For example, A1 is 1/1/2008 and B1 is 1/10/2008 so I want C1 to show 9

Thanks.

 

[Niek Otten]

=B1-A1, Format as General, not as Date (which Excel does automatically)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In Column A, I have a list of dates. (MM/DD/YYYY)
| In Column B, I have another list of dates. (MM/DD/YYYY)
|
| What's the formula, in Column C, to determine the difference in the number
| of days between Columns A and B?
|
| For example, A1 is 1/1/2008 and B1 is 1/10/2008 so I want C1 to show 9
|
| Thanks.

 

[Guest]

Never mind. I got it.

I had done A1-B1 but got a wierd date. Then, I realized that I needed to
change the format of C1 to General. That fixed it.

Dan

 

[Stan Brown]

Fri, 20 Apr 2007 08:10:05 -0700 from crimsonkng

In Column A, I have a list of dates. (MM/DD/YYYY)
In Column B, I have another list of dates. (MM/DD/YYYY)

What's the formula, in Column C, to determine the difference in the number
of days between Columns A and B?

For example, A1 is 1/1/2008 and B1 is 1/10/2008 so I want C1 to show 9

=B1-A1