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 |