select count(*) from table where
DATE1 between '20110325' and '20110325'
or
where DATE2 between '20110325' and '20110325'  
or
where DATE3 between '20110325' and '20110325'