With a year entered in cell J1, I need formulas to create a list of
Mondays (day only) for each month in column B starting at cell 10 (B10)
based on the entry in J1.
Five cells are allocated per month so if there is only 4 Mondays in a
month, it's 5th cell should be blank.
For example if J 1 has 2006,
January B10 = 2
January B11 = 9
January B12 = 16
January B13 = 23
January B14 = 30
February B15 = 6
February B16 = 13
February B17 = 20
February B18 = 27
February B19 = (blank, no more Monday's in month)
March B20 = 6
March B21 = 13
March B22 = 20
March B23 = 27
March B24 = (blank, no more Monday's in month)
etc
--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread:
http://www.excelforum.com/showthread...hreadid=547251