How to Calculate No. of Days between two dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
=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.
 
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
 
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
Click to expand...

=B1-A1
 
Back
Top