Return the first Wednesday of each month
In A2:
=DATE(YEAR(A1),MONTH(A1)+MIN(1,ROWS($1:1)-1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+MIN(1,ROWS($1:1)-1),4))
copy down to A13
"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
|