I have a formula set to count the number of taxable daysin a year based on
the closing date of the transaction. The problem is, I have used the
=DATE360 function which is 5 (or 6) days off and is causing a problem.

My current function reads:
=IF(C2=0,0,(DAYS360(D2,E2))) C2=Jan 1 of current year; D2 = Jan 1 minus 1
; E2=.ref to closing date cell

The number of days is then mul;tiplied by the daily tax raite of the
property which is figured by annual tax/365.
See the problem? Has anyone run into this issue? Do you have a workaround
formula?


Thanks so much!
-Monica