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
|