Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need cell formulas to return the day of every Monday in a month based on year entered
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need cell formulas to return the day of every Monday in a month based on year entered
B10: =DATE(A1,1,1)-WEEKDAY(DATE(A1,1,1),2)+1+(WEEKDAY(DATE(A1,1,1),1) <2)*7
B11: =IF(YEAR(B10+7)=$A$1,B10+7,"") copy B11 down -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "mikeburg" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need cell formulas to return the day of every Monday in a month based on year entered
Thanks so very very much, mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=547251 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I highlight a cell if it meets year and month criteria | Excel Worksheet Functions | |||
Finding the date on the 'nth' Monday in this Month in this Year | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
return array result in cell based on comparing dates | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |