Quote Originally Posted by davesexcel View Post
Try This

=IF(A1<DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),"over","Under")

That works ..


Now if i have a full columns of this and i want to verify every cells of this column and add on the next cell "Over" Or "Under"

how would that be in VBA scripting ?

thanks