Dates360 formula in Excel for Access

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.
 
M

Michel Walsh

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
 
M

Michel Walsh

.... 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
 

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

Calculating 360 day years using DAYS360 1
Expanding Date formula 1
Trailing 30 days sum calculation with excel 1
Excel Microsoft excel interest formula 2
Days per month 14
Date Calculation - Astro Calculation 2
Average last 30 days for each day in the quarter 7
360-day Year Based Payment & Amortization Calculations? 1

Top