View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
intruder9
 
Posts: n/a
Default "DAYS 360" and the date Feb 28th as start and end


You are using this function in a way that it was not designed to be
used.

Days360(StartDate, EndDate) returns the number of days between
StartDate and EndDate based on a 360-day year (i.e., all months contain
30 days). If EndDate is earlier than StartDate, NumDays is negative.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=518141