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
|