View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Per day average using DAY360

How many days do you consider there are between Feb 1/07 and Mar 1/07? If
you want the fictictious number of 30 days, then continue using Days360. If
you want the actual number of days (28), then just use subtraction, as in:

=(h12-h14)/(g11-g13)

Regards,
Fred.

"Peo Sjoblom" wrote in message
...
Format as general



--


Regards,


Peo Sjoblom



"Mark" wrote in message
...
This seems so simple, but I need divide a value by the day360 formula. I
entered =(H12-H14)/DAYS360(G13,G11) i get back 10/24/1908

thanks