View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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!