Per day average using DAY360

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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
 
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.
 
Back
Top