Days365?

[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

 

[J.E. McGimpsey]

Since XL dates are just integral offsets from a base date (31Dec1899
for windows default), you can use regular math functions:

A1: 15 Oct 2003
A2: 30 Oct 2003
A3: = A2 - A1 ====> 15

You may need to reformat A3, as XL's parser mistakenly thinks that
subtracting a date from another date should return a date.