Thursday, September 1, 2016

Randomly select a day of the week in Excel

The Task

Create an Excel spreadsheet that includes a formula designed to pick a day out of the week at random using spreadsheet software such as Microsoft Excel.

You will need to use one of Excel's random functions to generate at least one random number as the basis of this exercise. That random number or perhaps a series of random numbers will then be needed to pick one of the seven days of the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday).


Notes

I would recommend including a list of the days of the week in Excel. This is an easier approach to solving this challenge, and it would be easier to reuse the formula for other reasons if you don't get in the habit of including everything in the formula itself. Should I return to this challenge in the future, I might try to apply this formula to other lists.

Feel Free to Comment

Try to find your own unique approach and share what you are doing in the comments section. These comments can help you and others find new ideas to explore. If you are desperate enough and can't figure out how to accomplish this task, you can always ask. I do not provide storage to those who visit my blog. If you would like to share any files, you are going to have to find your own online storage. At that point, you can provide links with your comments. I would like to point out that macros can create security risks. If possible, save all documents as a standard workbook (not macro-enabled) unless macros are vital to your solution. If you are going to download any solutions, make sure that you are not loading macros by default. If a spreadsheet includes macros, check the code before running them.

Follow-up

No comments:

Post a Comment