View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikhil Nikhil is offline
external usenet poster
 
Posts: 44
Default Find 2nd & 4th saturday for every month

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