Dates360 formula in Excel for Access

  • Thread starter Thread starter carrie
  • Start date Start date
C

carrie

Does anyone know if access has a similar formula to Excel's Dates360?

Dates360=Returns the number of days between two dates based on a 360-day
year (twelve 30-day months), which is used in some accounting calculations.
Use this function to help compute payments if your accounting system is based
on twelve 30-day months.
 
Not right out of the box, but you still can write your own VBA function, in
a standard module, which would call the Excel function (through automation,
if required). I don't know that Excel function, though.



Vanderghast, Access MVP
 
.... and it seems it does not exist with Excel 2003. At least, the object
browser (F2) does not find it, even after having added a reference to Excel
2003.


Vanderghast, Access MVP
 
Back
Top