View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
H Halliburton H Halliburton is offline
external usenet poster
 
Posts: 4
Default Need help refining this formula

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.

Thanks for any help!