Dear All,
I want macro or formula for the below mentioned querry pls help i am
entering data's in cell A, B and output to be displayed in cell C as follows

A B C
01/11/06 02/11/06 1
NA NA NA
NO NO Voilated
01/11/06 NO Should show no for days from A cell
to today
01/11/06 NA 1