Per day average using DAY360
 

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

Per day average using DAY360
 

Just format the result as General
Bob Umlas
Excel MVP

"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

Per day average using DAY360
 

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

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