In cell A1 I have the date 1/1/2011 formatted as "yyyy"

In cell A2 I have =DATE(YEAR($A$1),"1","1") formatted as "mm"

In cell B2 I have =IF(NOW()>=A2,IF(MONTH(NOW())=MONTH(A2), DAY(NOW()),EOMONTH(A2,0)),"") formatted as "dd"

Now in another sheet I have math going on but for the sake of this post lets just say that my math is now in cells H5:H16

using this formula: =IF(I5="Y",B2-1,"")

(now what this is saying it that if my tenant is late on rent I want to it to multiply the late charge (in cell H2 ($5))by the number of days that have pasted minus 1 day.

So for example January has 31 days. Rent is due on the first however everyday after the 1st a $5 late fee is accumulated. So in cell H5 it displays the number of days they are late. In this case it is 30 days. However if you do the format to a number it shows me 40573 instead of 30. So when I try to multiply the number of days they are late by the late fee it gives me $1,646,208,902.00

Seems my tenants might be a little upset by this so I was wondering if anyone could give me a hand.