View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Philippe_L
 
Posts: n/a
Default Bug in days360 function

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?