Days360 module with rounding

[smg]

Hello,
I have the following module to replicate Days360:


Public Function GetMonths360(TimesheetDate As Date, ReleaseDate As Date)
GetMonths360 = ((Year([TimesheetDate]) - Year([ReleaseDate])) - 1) * 360 + ((12 - Month([ReleaseDate])) * 30) + (30 - Day([ReleaseDate])) + ((Month([TimesheetDate]) - 1) * 30) + (Day([TimesheetDate]))
GetMonths360 = -Int(-GetMonths360 / 30)
End Function

Int or -Int rounds too far down or up

I want this to round as would ROUND(DAYS360(V7,X7)/30,0, where 45 days between two dates would count as 1 month and 46 days and greater would count as 2 months, any suggestions?

[CJ_London]

use the backslash?

?40\46
0
?45\46
0
?50\46
1
?150\46
3


so the calculation might be

iif(myvalue\46,2,1)

or simply

iif(myvalue<=45,1,2)