360 day calendar function
 

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

360 day calendar function
 

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" wrote in
message ...

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

360 day calendar function
 

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" wrote in message
...

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