View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default VBA code help for item tracking.

Just use the AND function
AND(B1="",TODAY()-A1120)

Mike F

"David" wrote in message
...
Myrna Larson wrote

=IF(AND(B1="",TODAY()-A1120))


Results in 'Your formula contains an error' i.e. needs something between
last 2 ))

--
David