Yes this is possible using Global Absence Entry Validation Fast Formula.
Please refer some sample examples.
Thank you Ashish, the fast formula in the attached file are very useful, because I am not familiar with fast formula. I will try to fit those fast formula into my cases. Thank you so much for your great help.