View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Return the first Wednesday of each month

Try this...

Enter this formula in A2. This will return the 1st Wednesday of the month
for the date entered in A1.

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-3)

Enter this formula in A3 and copy down as needed. This will return the 1st
Wednesday date for the subsequent months.

=A2+28+((DAY(A2+35)<8)*7)

Format as Date

--
Biff
Microsoft Excel MVP


"dalymjl" wrote in message
...

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