I thought my formula was working but not accurate:

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-P1

where P1 has a due date in it.

I am trying to calculate based on P1 how many days an item will be projected
past due at month end.

So if P1 had 5/15/2008 in it, and I ran the report today in June at June
month end it would be 45 days past due, and if its past due when i run again
in July the value would be 76 days past due.

What am i doing wrong?

Thanks!