Need help refining this formula
Where did the 19 come from? Is that a day to check against no matter what
day is shown in the payment due date? Or is that the number in the payment
due date and you just manually entered it in your formula? My guess is that
you would want to know whenever Column B's date is later than Column A's
date, right? If so...
=IF(OR(B61="",B61A61),48.44,0)
although perhaps you may want the to be = instead.
--
Rick (MVP - Excel)
"H Halliburton" wrote in message
...
Right now I have this formula
=IF(OR(B61="",DAY(B61)=19),48.44,0)
The problem I'm having is if the month or year changes it isn't reconizing
that the payment is late. How do I change it so it will calculate that the
payment is late.
I guess I sould of said that column A has the payment due date and Column
B
has the date the payment was made.
Thanks
Thanks for any help!
|