Search Contextures Sites
Do you use the CHOOSE function?
Nov 24, 2015
Get the fiscal month, list all files, custom icons, and much more, in this week's Excel news.
- Debra - email@example.com
Calculate Fiscal Month
The CHOOSE function doesn't get talked about too much, but it is very powerful -- just give it a number, and it will return a result. One way that I use CHOOSE is to show the fiscal month for a specific date.
For example, if a company's fiscal year starts in July, the CHOOSE function could give us the fiscal month number, if the calendar month is 11.
- The MONTH function gets the month number (11) for the date in C2.
- The result is the 11th item in the string of numbers -- 5.
To see how old an Excel file is, and other properties, click the File tab on the Ribbon, then click the Info category at the left. You'll see the properties and dates at the right.
If you want a list of all the files in a folder, and their properties, I've created a macro that you can download. In the sample file, just enter a file path, and click the button to run the macro.
Here are a couple of Excel articles I read recently, that you might find useful.
Create Icons -- Instead of using conditional formatting icons, which can slow down your workbook, Jordan Goldmeier shows how to use custom number formatting to create icons on a dashboard. (Level - Intermediate)
Office 2016 Review -- If you're not sure whether to update, Zack Barresse has been using Office 2016 for a while now, and posted his review of the new features. (Level - Basic)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.
There will be at least a couple of Black Friday and Cyber Monday sales for Excel related products. To see the list, go to my What's New page. I'll keep updating the list, so check again on Friday and Monday!
Do You Want to Build a Snowman?
We had a very light dusting of snow on Sunday, and my granddaughter decided that we should go out and build a snowman. I think she has seen the Frozen movie too many times! She managed to scrape together a bit of snow, and it was just right for building the world's tiniest snowman. We couldn't find a tiny carrot for its nose though.
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser: http://www.contextures.com/newsletter/excelnews2015/20151124ctx.html
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2015
All rights reserved.