Formating dates
 

I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

Formating dates
 

=B1-A1 format as general (end date - start date)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"pcor" wrote in message
...
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

Formating dates
 

Hi!

A1 = start date/time
B1 = end date/time

=INT(B1)-INT(A1)

Biff

"pcor" wrote in message
...
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

Formating dates
 

Oops! didn't read far enough, see Biff's answer

Peo


"Peo Sjoblom" wrote in message
...
=B1-A1 format as general (end date - start date)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"pcor" wrote in message
...
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

Formating dates
 

I guess I did not explain well enough
In A1 I have Wed 12 Apr 2006 01:46:PM
In B1 I have Tue 11 Apr 2006 04:41:PMTThat give me an answer of 21 hrs 4
min and a few seconds.
What I really wnat is the number of days(in this case it wouod ab e about
..8(point 8)
How can I do that
Thanks


"Biff" wrote:

Hi!

A1 = start date/time
B1 = end date/time

=INT(B1)-INT(A1)

Biff

"pcor" wrote in message
...
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

Formating dates
 

As long as these dates are true Excel dates then just subtract:

=A1-B1

Format the cell as GENERAL

Result = 0.878472222218988

Biff

"pcor" wrote in message
...
I guess I did not explain well enough
In A1 I have Wed 12 Apr 2006 01:46:PM
In B1 I have Tue 11 Apr 2006 04:41:PMTThat give me an answer of 21 hrs 4
min and a few seconds.
What I really wnat is the number of days(in this case it wouod ab e about
.8(point 8)
How can I do that
Thanks


"Biff" wrote:

Hi!

A1 = start date/time
B1 = end date/time

=INT(B1)-INT(A1)

Biff

"pcor" wrote in message
...
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

Formating dates
 

Worked Great Thanks


"Biff" wrote:

As long as these dates are true Excel dates then just subtract:

=A1-B1

Format the cell as GENERAL

Result = 0.878472222218988

Biff

"pcor" wrote in message
...
I guess I did not explain well enough
In A1 I have Wed 12 Apr 2006 01:46:PM
In B1 I have Tue 11 Apr 2006 04:41:PMTThat give me an answer of 21 hrs 4
min and a few seconds.
What I really wnat is the number of days(in this case it wouod ab e about
.8(point 8)
How can I do that
Thanks


"Biff" wrote:

Hi!

A1 = start date/time
B1 = end date/time

=INT(B1)-INT(A1)

Biff

"pcor" wrote in message
...
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian