360 day calendar function

is anyone familiar with entering dates pre 1800's ? I'm trying to use the following function =DAYS360() between two dates however, any date i enter before 1900 gives me an error.

Take a look at John Walkenbach's XDate add-in:

http://j-walk.com/ss/excel/files/xdate.htm


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lemor" <[email protected]> wrote in
message news:[email protected]...
>
> is anyone familiar with entering dates pre 1800's ? I'm trying to use
> the following function =DAYS360() between to dates however, any date i
> enter before 1900 gives me an error.
>
>
> --
> Lemor
> ------------------------------------------------------------------------
> Lemor's Profile:
http://www.excelforum.com/member.php...o&userid=37010
> View this thread: http://www.excelforum.com/showthread...hreadid=567329
>

As you've found out, Excel is not good at dates before Jan 1/1900.

In addition, you should know that DAYS360 does not give an accurate difference
in every case. You should use simple subtraction (ie, =b1-a1) to get the true
number of days between two dates.

--
Regards,
Fred


"Lemor" <[email protected]> wrote in message
news:[email protected]...
>
> is anyone familiar with entering dates pre 1800's ? I'm trying to use
> the following function =DAYS360() between to dates however, any date i
> enter before 1900 gives me an error.
>
>
> --
> Lemor
> ------------------------------------------------------------------------
> Lemor's Profile:
> http://www.excelforum.com/member.php...o&userid=37010
> View this thread: http://www.excelforum.com/showthread...hreadid=567329
>