Let's say you have a date stored in cell C8. To make this happen, you can create a helper worksheet (called 'Dates') where column A:A is just a column of numbers 1:55000 formatted as dates (A1=, A2=, etc.), recognizing that the stored value for a date is simply a number ( is 42736). The rest of the items in the list are just calculated from those two cells as shown. Cell C2 is finding the most recent date in the Date column. The formula in A6 is adding +1 to the current maximum check number in the Num column. The lists used for the dynamic drop-downs need a home, so for this example we can create a new worksheet and create the lists as shown in the image below. Setting up the Dynamic Drop-Down Lists Step 1: Create the lists (Note: after writing this article and creating these images, I found that I also wanted to list the previous two check numbers). So, for the drop down list in the Num column, we can list the next three check numbers. We can still enter the date manually if we want to.Īs you may know from your own experience, checks that you write are not always deposited in the order you write them. It would be much better if Microsoft provided a convenient built-in date picker tool, but this approach provides a useful substitute for now. The list of dates includes the most recent date plus the dates for the next week.

Create a drop down list in excel