Hello there,

You do not actually need the Date360 function if you are
using just regular years.

You just need to find the difference between the two
dates and format the result to be a regular number:

A14 - 01/30/2005
B14 - 02/01/2005
C14 - B14-A14

This will give you a date in return.
Format this to be a regular number. Shortcut to this is:
Select the cell and Ctrl + Shift + #

Hope this helps

Judith

-----Original Message-----
i tried to write the formula to calculate the days.
A14(starting) B14 (ending) days
including starting & ending
1/30/2005 02/01/2005 =DAYS360
(A14,B14)+1
but I just can get 2 days. In fact it should be 3 days.
I found that if
there is 31 days
in the month, the case will be like this. I tried to
change the days360 to
days363 in formula. But I am not allowed. tks in advance
Sue
.