Contextures News 20151124

Excel CHOOSE Function

November 24, 2015

Get the fiscal month, list all files, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

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.


calculate fiscal month

  • 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.

You can see more examples for CHOOSE.

File List

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.

Excel Articles

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.

Black Friday

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.

Weekly photo

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:

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.


Last updated: May 24, 2021 8:14 PM