From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Building a flexible monthly table using functions

Building a flexible monthly table using functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Building a flexible monthly table using functions

- In this worksheet, we're setting up a data entry vehicle for someone who doesn't necessarily know a lot about Excel. Ultimately, all this person or persons will be doing is selecting a month in cell A2, and as I click there, you'll see a drop arrow, it's a picklist, I'll show you how to do that by way of data validation. Same thing in column B, in cell B2, we pick a year, and depending upon that choice, we want our display here to reflect how many days there are in that month. Now, I've hidden some of the rows ahead of time because, as we look at this model, we want to be viewing some of the early days along with the other data here, and then the later days toward the end of the month. So you'll notice that rows 14, and then we see row 29. The other rows have been hidden. So, let's talk about how this is set up. And a lot of different functions are in use in this model, including the ones we see over here. These are simply here for reference purposes; eventually, we'd get rid of…

Contents