| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Has @DAYS 360 function calculated differently between qtr and mon
I'm calculating interest in a spreadsheet and use this function to calculate
the number of days between dates. I have a quarterly calculation but was asked to calculate monthly during the same period and have come up with a difference in the number of days. How do I reconcile? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Has @DAYS 360 function calculated differently between qtr and mon
On Wed, 18 Jun 2008 10:41:00 -0700, somthinls2
wrote: I'm calculating interest in a spreadsheet and use this function to calculate the number of days between dates. I have a quarterly calculation but was asked to calculate monthly during the same period and have come up with a difference in the number of days. How do I reconcile? Start by posting examples of your data, formulas, actual results and desired results. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date glitch? First 12 days of month format differently than the r | Excel Discussion (Misc queries) | |||
| Can I use IF function in calculated fields in a pivot table? | Excel Worksheet Functions | |||
| Can Function results be calculated? | New Users to Excel | |||
| Custom Function not being auto calculated when cells change..help? | Excel Worksheet Functions | |||
| need help using the offset function differently | Excel Worksheet Functions | |||
Hybrid Mode
