I am making a spredsheet that details creditors by date of last payment.I can
create the formula comparing the days from "now" to the next due date and
mark it "current" or "attention" if its within 30 days but my problem is that
for creditors that are overdue the "dateif"formula will not work as the
calculation will not accept going backwards into negative days.Can anyone
give me a little guidance as Ive mucked around for far to long.
In anticipation Kent