Days360 versus DatedIf versusDateDiff

[smg]

I get a different results with all three formulas as shown below, but my customer wants Days360 which is not in Access. Anyone know how to get to Days360 result in Access query?

[June7]

No formulas nor results shown.

[Cottonshirt]

Anyone know how to get to Days360 result in Access query?

there are a number of solutions given on this page.

good luck with your project,



Cottonshirt

[June7]

Followed those calcs and built VBA function. Gives same result as Excel.

Function Days360(dteStart As Date, dteEnd As Date)
Days360 = ((Year(dteEnd) - Year(dteStart)) - 1) * 360 + ((12 - Month(dteStart)) * 30) + (30 - Day(dteStart)) + ((Month(dteEnd) - 1) * 30) + (Day(dteEnd))
End Function

[smg]

Attached is what I get for the VBA function as well as DateDiff, DatedIf and Days360. You will see that none of these match Days360 100%. Maybe this is the closest I can get? Or, any other ideas?

[June7]

I ran into a similar issue attempting to translate Excel cell formulas into Access VBA. Calcs involved matrix multiplication. I compared cell formula calcs with running Excel functions in VBA as well as strictly VBA. Got 3 different output.

[smg]

Thank you for you assistance, I will have to let my customer know he has to pick one of the three in access.

[smg]

how do I get a query to use this function?

[June7]

Which function?

Put VBA custom function in a general module. Then it can be called in query.

[smg]

Great, thanks