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
|