View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Terry is offline
external usenet poster
 
Posts: 88
Default Date help please

Appreciated Peter

Terry

"Pete_UK" wrote in message
...
In which case you can amend it further to:

=IF(K3 $R$3, "LATE","")

to get the same effect more efficiently.

Hope this helps.

Pete

On Feb 11, 6:01 pm, "Terry" wrote:
OK Peter

Amended formula to include = along with <, , to rid the "false" kicking
in.

Terry