Per day average using DAY360

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
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average using Sumproduct 4
Pivot Tables - get a total different than the summarize field sett 1
Calculating an average of data between two dates 1
Date calculations resulting in negative numbers and averages 4
Trying to find additional ranges outside of min, max, and average 2
If Statement to subtract “time†if condition met 7
Avoiding cells being included in a chart 4
Month days over a time period 5

Top