View Single Post
  #2   Report Post  
bill k
 
Posts: n/a
Default


=IF(AND(($A$9-A12)<=60,($A$9-A12)31),B12,"")

A9 has =today()
a12 is the date of invoice
b12 is amount of invoice


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=474400