Look he

http://www.cpearson.com/excel/DateTimeWS.htm

heading "Nth day of month and year"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Nikhil" wrote in message
...
I enter a date in one column, in the second column i want the day for that
date. If the day happens to be the 2nd or the 4th saturday in that month,
it
should get highlighted. How do i calculate the 2nd & 4th saturdays?

Rgds