Conditional Format specific Date(s) Not year

[legogeek]

I'm looking for a Conditional Format formula the looks in Column F (list of dates) for 3 dates (4/1, 6/1, 9/1) and then apply's a red top border color to the whole row.
The range I'm working in is =$A$31:$BH$395
Column F's CELL Dates are displaying in "14-Mar" format. The dates are entered like 4/1/2014.

I've tried a conditional format rules:
=$F31="31-Mar" applies to =$A$31:$BH$395
=$F31="4/1/2014" applies to =$A$31:$BH$395

I'm not sure how to try using maybe DATE as apart for my formula. Any suggestions? Again the goal is to find these specific dates (4/1, 6/1, 9/1) to apply the upper boarder to the row... The year will change obviously each year so if that can be excluded from this formula that would be best.

 

[njimack]

=and(day($f$31)=1,or(month($f$31)=4,month($f$31)=6,month($f$31)=9))

 

[legogeek]

Neil Thanks!

At first it didn't work but then I realised the rows were locked. After I changed it to:
=and(day($f31)=1,or(month($f31)=4,month($f31)=6,month($f31)=9)) everything works beautifully!.

Thanks again!