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

Not that I'm aware of.
. . . Or is there a way to construct one from scratch myself and add it
to Excel?
Click to expand...

Try

=LaterDate-EarlierDate
+SUMPRODUCT(-(TEXT(ROW(INDIRECT(EarlierDate&":"&LaterDate)),"ddmm")="2902"))

This will work as long as your dates fall between 1-Jan-1900 and 5-Jun-2079.
 
Back
Top