Has @DAYS 360 function calculated differently between qtr and mon

S

somthinls2

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?
 
R

Ron Rosenfeld

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?
Click to expand...

Start by posting examples of your data, formulas, actual results and desired
results.
--ron
 

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

Calc days between two dates and exclude leap year days 6
Difference of two dates 3
Interest and Payment Calculations 6
Days between 3
I need calculated time in a "real number" format 2
DAYS360 function for 365 day year 3
credit intrest on intrest 1
Function to calculate the nuber of weeks between dates? 4

Top