B
Belinda7237
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!
=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!