in my sheet, column a and column b have dates.
column b the dates are being seen properly as dates
column a they are being seen as date serials.

is there an easy way to correct this so that days360()
formula will work properly.

alternately, is there an easy way to convert the serial
date into a date that days360() formula will work properly.

Hi
does formating the column as 'date' help?

--
Regards
Frank Kabel
Frankfurt, Germany

"Scott" <(E-Mail Removed)> schrieb im Newsbeitrag
news:5e8401c4815d$9fff8040$(E-Mail Removed)...
> in my sheet, column a and column b have dates.
> column b the dates are being seen properly as dates
> column a they are being seen as date serials.
>
> is there an easy way to correct this so that days360()
> formula will work properly.
>
> alternately, is there an easy way to convert the serial
> date into a date that days360() formula will work properly.
>

unfortunately that didn't help.
formatting as date for some reason is still seeing the
serial but showing the date properly.

>-----Original Message-----
>Hi
>does formating the column as 'date' help?
>
>--
>Regards
>Frank Kabel
>Frankfurt, Germany
>
>"Scott" <(E-Mail Removed)> schrieb im
Newsbeitrag
>news:5e8401c4815d$9fff8040$(E-Mail Removed)...
>> in my sheet, column a and column b have dates.
>> column b the dates are being seen properly as dates
>> column a they are being seen as date serials.
>>
>> is there an easy way to correct this so that days360()
>> formula will work properly.
>>
>> alternately, is there an easy way to convert the serial
>> date into a date that days360() formula will work
properly.
>>
>
>.
>

Hi
now I'm confused :-)
What are you trying to achieve exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

<(E-Mail Removed)> schrieb im Newsbeitrag
news:5f2301c48167$1e3682c0$(E-Mail Removed)...
> unfortunately that didn't help.
> formatting as date for some reason is still seeing the
> serial but showing the date properly.
>
> >-----Original Message-----
> >Hi
> >does formating the column as 'date' help?
> >
> >--
> >Regards
> >Frank Kabel
> >Frankfurt, Germany
> >
> >"Scott" <(E-Mail Removed)> schrieb im
> Newsbeitrag
> >news:5e8401c4815d$9fff8040$(E-Mail Removed)...
> >> in my sheet, column a and column b have dates.
> >> column b the dates are being seen properly as dates
> >> column a they are being seen as date serials.
> >>
> >> is there an easy way to correct this so that days360()
> >> formula will work properly.
> >>
> >> alternately, is there an easy way to convert the serial
> >> date into a date that days360() formula will work
> properly.
> >>
> >
> >.
> >