View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Bug in days360 function

This is not a bug, its a "featu

From Help:

FALSE or omitted (the third parameter)

U.S. (NASD) method. If the starting date is the 31st of a month, it becomes
equal to the 30th of the same month. If the ending date is the 31st of a
month and the starting date is earlier than the 30th of a month, the ending
date becomes equal to the 1st of the next month; otherwise the ending date
becomes equal to the 30th of the same month.

--
Gary''s Student


"Philippe_L" wrote:

Hi,

If you enter days360(A1,A2) where A1 is April, 18, 2006 and A2 is
March, 31, 2007 you get correctly 343 days.

BUT if you enter it the opposite way, i.e. days360(A2,A1), you get -342
days.

My HP calculator disagrees with this, and gives logicaly 343 and -343.

Any explanation?