You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Bill Jelen has been running the MrExcel podcast for years now. For those that haven’t heard of it, it’s a frequently updated video podcast that teaches you Excel, showing everything from the basics of the fill handle to advanced tips around charting, and everything in between … including some recent tricks with linked pictures. Since there’s a lot of great information in his videos, we thought that a weekly (or so) wrap-up of his podcast would be a nice thing to add to the blog. If you have ideas for more community showcasing & interaction please send me an email via the link at the top of the blog.
Here’s a recap of some recent MrExcel videos:
Episode 1181: Learn how to create a dropdown that allows you to change the chart displayed on your worksheet, without code!
Episode 1182: Bill Jelen and Mike Gel Girvin show you how to visually present statistical values (+/-) in a cell.
Episode 1185: Mike and Bill get together again and tackle counting the number of Mondays between two dates.
Bill and Mike had great ways of solving the problems, would you do it a different way? Check out these and many more Excel videos at http://www.mrexcel.com
Comments: (2) Collapse
Regarding the Monday count, the further apart the dates are the performance of the calculation deteriorates, although the dates may need to be wildly far apart to notice. Also, the use of volatile functions is not always desirable. Another possible solution is:
=INT((B10-B9+1)/7)+IF(MOD(B10-B9+1,7)>(IF(WEEKDAY(B9)>A12,A12+7-WEEKDAY(B9),A12-WEEKDAY(B9))),1,0)
Where B9 and B10 are the inclusive dates as in the video, and A12 references the numeric day of the week being counted (in this case 2 for Monday). I expect this can be tidied up a little.
Hi,
I want know about new excel mobile 2010
Comments: (loading) Collapse