Days365?

  • Thread starter Thread starter Frmr97GXE
  • Start date Start date
F

Frmr97GXE

Is there an add-on with a Days365 function similar to Days360 that would
find a difference between two dates based on a 365 day year? Or is
there a way to construct one from scratch myself and add it to Excel?

Thank you,
Ilya
 
Hi

I'm not sure about 365 day year, but there is an undocumented function
DATEDIF(), which calculates the difference between 2 real dates. Read about
it in Help.
And what about formula
=EndDate-StartDate
 
Arvi, thanks, my search turned up DATEIF as well, but I can't seem to
find it in my Help and my Excel 97 (yes, my bank is that cheap) refuses
to recognize it. As for just subtracting the two dates from each other
- it gives an actual number of days, what I need is something that
assumes 365 days even in leap years. It's for a net interest income
calculating model I'm building.
 
Hi

In this case
=(YEAR(B1)-YEAR(A1))*365+(B1-DATE(YEAR(B1);1;0)-AND((MONTH(DATE(YEAR(B1);2;2
9))=2);B1>DATE(YEAR(B1);2;28)))-(A1-DATE(YEAR(A1);1;0)-AND((MONTH(DATE(YEAR(
A1);2;29))=2);A1>DATE(YEAR(A1);2;28)))

Maybe you can simplify it somewhat - I left it as as calculation logic was,
so it's easier to follow it. It must work no matter which version of Excel
you have.
 
Back
Top