Get Weekday Occurrence
As in February 17, 2006 is the 3rd Friday of that month, Cell A1 has the date to be calculated
=INT((DATE(YEAR(A1),MONTH(A1),DAY(A1))-DATE(YEAR(A1),MONTH(A1),1))/7)+1
© Copyright 2004 - 2010,
andrewsexceltips.net
All Rights Reserved.