| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
