ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Has @DAYS 360 function calculated differently between qtr and mon (https://www.excelbanter.com/excel-worksheet-functions/191796-has-%40days-360-function-calculated-differently-between-qtr-mon.html)

somthinls2

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?

Ron Rosenfeld

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


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com