Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Misc
Need cell formulas to return the day of every Monday in a month based on year entered
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="mikeburg, post: 8453977"] With a year entered in cell J1, I need formulas to create a list o 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 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) et [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Misc
Need cell formulas to return the day of every Monday in a month based on year entered
Top
