School taxes run beginning each year on 7/1/09, muni and county taxes run 1/1/09.
I have a calculation that provides the number of proration days except, depending upon time of year, it will give a negative number. So it's' not helpful.
=(DAYS360(Data!N2,'Personal Est - Cost to Sell&Buy'!N52))
I can add 360 to those minus days and get the correct answer but how would I code this to react properly?
Bookmarks