View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Return the first Wednesday of each month

=DATE(YEAR(A1),MONTH(A1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))



"dalymjl" wrote:


If I put a date in cell A1 (1/1/2010) how do I get the first wednesday
in each month in 2010 to display in cells A2:A13 i.e
6/1/2010
3/2/2010
3/3/2010 etc.?




--
dalymjl