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

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"pcor" <[email protected]> wrote in message
news:[email protected]...
>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

Hi!

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

=INT(B1)-INT(A1)

Biff

"pcor" <[email protected]> wrote in message
news:[email protected]...
>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

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

Peo


"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:%[email protected]...
> =B1-A1 format as general (end date - start date)
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
> "pcor" <[email protected]> wrote in message
> news:[email protected]...
>>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
>
>

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>

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

=A1-B1

Format the cell as GENERAL

Result = 0.878472222218988

Biff

"pcor" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>>
>>
>>

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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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
> >>
> >>
> >>
>
>
>