Excel past due field

Yes you have to turn them into numbers, I wrote a time sheet that has something similar, that did the time, (hours/minutes, which I believe you can extrapolate from there.)

Its on my other computer ......I'll post when I get it get it, should be today yet.

You can pm me your email, and I'll sent the whole thing over too.

p911

Hi Apothicus,

I just tried this. Make sure your dates are in Date format. I used MM/DD/YYYY.

If your due date is in B2 and your Today's date is in C2, in D2 type =C2 - B2. It worked. I thought it would not be so straightforward.

Mike

Tried it in Open Office clone of Excel and this seems to work:

in cell A1, format for date and enter due date

in cell B1, enter

=IF(TODAY()-A1>0;TODAY()-A1;"")

Format cell B1 for number (not date).
Formula calculates difference between current date and due date in number of days.
If past due, days greater than 0, number of days shown in B1
If NOT past due, days less than/equal to zero, B1 left empty

Syntax and specific command may be slightly different, but Excel should have equivalents.

Among other functions EXCEL has "date"; "year" and "month" I could fora statistical analysis of CR4 obtain for instance since how many month the participant was a member.

I thank all who answered, I now have it figured out at least two different ways.

I should be able to track all those delliquent payers at a glance.

Thanks again.

mike is right