DATE360() Function Excel v.X

[William Kanoff]

I am using Excel v.X 10.1.5 with OS/X 10.3.

DATE360("2/10/04","3/10/04") = 30.

Not the correct answer. What ever month I put in brings an answer of
thirty. Any posible solutions?

 

[Bernard Rey]

William Kanoff wrote :

DATE360("2/10/04","3/10/04") = 30.

Not the correct answer. What ever month I put in brings an answer of
thirty. Any posible solutions?

The answer is correct for US date settings (m/dd/yy). If the answer you
expect is "1", try DATE360("10/2/04","10/3/04")

 

[J.E. McGimpsey]

I am using Excel v.X 10.1.5 with OS/X 10.3.

DATE360("2/10/04","3/10/04") = 30.

Not the correct answer. What ever month I put in brings an answer of
thirty. Any posible solutions?

if you mean DAYS360(), 30 is *exactly* correct - the function
returns the difference between dates as if there were 12 30-day
months. From Help (if you're not using it, you really should - it's
gotten *much* better in the last two versions):

Days360
Returns the number of days between two dates based on a 360-day year (twelve
30-day months), which is used in some accounting calculations. Use this
function to help compute payments if your accounting system is based on
twelve 30-day months.

Since XL stores dates as integral offsets from a base date (1/1/1904
by default for Macs), to get the actual number of days, just
subtract:

A1: 2/10/04
A2: 3/10/04
A3: =A2-A1 ===> 29

You will probably have to reformat A3 as General or another number
format - XL's parser improbably believes that subtracting two dates
should yield another date (I can't imagine under what circumstances
that would be true).