Search Contextures Sites
Custom Search

Contextures News

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 -  ddalgleish@contextures.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.

=CHOOSE(MONTH(C6),7,8,9,10,11,12,1,2,3,4,5,6)

  • 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, and it is one of the functions included in my 30 Excel Functions in 30 Days kit.

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.

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

_____________

________________________

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

 

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

__

 

Privacy Policy

 

Contextures Inc., Copyright 2015
All rights reserved.