How To Create A Date Drop Down List In Excel 2013


It is useful to learn how to create a dropdown list in Excel 2013 if you regularly engage in data entry and wish to save a whole lot of time. (You can position the drop-down list in most any cell or even multiple cells. In the list I have as many as 600 names. Simply list down all the entries that you. I love using drop down lists in Excel! They are extremely simple to create and are a great way to make a spreadsheet easier to use. To use this, select an empty cell directly underneath your data and right click. This will ensure that the date selections fall within a valid range of dates, that is, those months with data in the table. That's easy. Drop-down lists are created using the Data Validation feature. The Excel sheet contains several drop down boxes where a person clicks a cell and chooses the item form a list. It might seem weird but it's really that easy. It also shows how to create a dropdown from another workbook, edit and delete data validation lists. Part 3: Steps to Create Drop Down List in PDFs ; Steps to Create Word Drop Down List The simple truth is that it is absolutely impossible to just copy and paste a cell that has drop down list from an excel document into your word document. Open your workbook in which you want to enter the drop-down list and follow the steps given below: 1. How to create drop down list in excel 2013, lookup list, dropdown list, dorp down, choose from list, MS Excel, point form the list, list of values Creating an Excel Drop Down List (a Step-by. I am working with Microsoft Office Professional Plus 2013. You don’t want to have to deal with multiple variations of “yes”, for example. There is an added sheet called "Drop Down List". Enter the list into the cells. Sometimes you have a sheet that you need other people to fill in. It is essential to create drop-down lists or combo boxes that contain predefined options that limit user errors and allow. If you want to give your Add-In a different filename you can do it now. Create a drop-down list. Create a Drop-down List. You don't want to have to deal with multiple variations of "yes", for example. Select Custom Lists to display the Custom Lists dialog box. If you want the list in multiple cells, select multiple cells. Add a Drop-Down List to the Selected Cells The Data Validation dialog box displays. In the Data Menu , click “Data Validation” Dropdownlist and then click “Data Validation”. I was wondering if there is a way when I clik on the drop down menu and type the first letter, automatically Excel shows all list with that letter. The DropDown list is filled in with XML using data validation. Hold down your Ctrl key and select the range A9:M10 using your mouse. Of course, you may use a complicated mix of INDIRECT and ROW formulas to achieve a dynamic dropdown list. Click on the Allow drop down menu and select List. the list is about categories of expenses (ie food, petrol etc). Sheet #1 Elements of Excel: Create a drop-down list Provide a more efficient worksheet by using drop-down lists in a cell where your customers can make a yes or no choice, pick a date from a calendar, or pick from another list you insert. Bottom Line: The complete Excel guide on how to create drop-down lists in cells (data validation lists). Under Allow,. Using the drop-down list saves lots of time and effort because it's always easy to select from the list instead of typing in each particular cell manually. Drop down lists refer to drop down menus from which you can select one of the given options. The tutorial demonstrates 4 quick ways to create an Excel data validation list (drop-down list) - based on a list of values, range of cells, named range and a dynamic dropdown. Date – Accept the only date. How to create drop-down lists in Excel. I can go into the cells with the validation and it shows that it is set up to be a validation with list. Please note: To create a drop down list the file type needs to be. Open an Excel workbook. To assist data entry, a field can be created with a drop down list. Sometimes you have a sheet that you need other people to fill in. That meets most of our day to day requirements. Creating a dropdown menu: To create a dropdown list in Excel, the first thing you will need to do is name your list of items. You have now completed the first way to create a drop down list in Excel through data validation. To create a drop down menu in your Excel worksheet: Open your Excel spreadsheet, then select the cell where drop down menu has to be inserted. Drop down list limits the user to choose a value from the list provided instead of adding values in sheet. So there you have it - three different methods to create a drop down list in Excel. How to Display a Text Value Based on the Number Returned. The Excel sheet contains several drop down boxes where a person clicks a cell and chooses the item form a list. In Excel, Book 1, column A, I have data on rows 1-100. Excel automatically creates an empty event procedure. Inserting multiple drop-down lists that is somehow linked together in Excel is very simple. There are cases where after you create the excel sheet, you would like to share it the team or set of peoples. Now, go out there and be dynamic! Download the Use a Data Validation list to create a quick dynamic Excel chart example file. Click in the cell where you want the list to appear. A validation drop down list. Using Data Validation to create look up lists in Excel 2013. If you need to extend the range showing the drop-down list you can do it two ways. From the menu, select Data > Validation. Here is the exact requirement: I have created a drop down menu in excel with three values – Critical, Major and Minor. Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. Note: if you don't want users to access the items on Sheet2, you can hide Sheet2. But I need these cells to display by default DD,MM,YYYY. the combobox drop down to display a list of allowed types and select LIST. Click in the cell where you want the list to appear. This article showed a simple way of creating a drop-down list and how cell's can be linked to the drop-down list value. Multi-Item Bullet Lists in a Single Cell in Excel 2013. This article shows you how to make a drop down list in excel. We are also introducing the ways using data validation and refering to data in other worksheets. In this tutorial we will use a list of 87 names that as we type into the drop down list, it searches the names, and the list shortens to show only those. In this article, we will introduce two methods to auto refresh the drop-down list. It's easy to add a drop-down list to a cell in Excel, but the process is not intuitive. Tom’s Tutorials for Excel: Sheet Selector Drop-Down List. How to make a drop down list in Excel: First of all open your excel sheet and select the cell on which you wish to create a drop down. If I add or delete a row from the middle of the table, my associated drop-downs are updated automatically. Could it be done that the operator of the sheet types in todays date into say A2 (the date column), and then all subsequent rows of A are a drop down of either todays date or the next two subsequent days?. I'm creating a template where the user has to fill the details. Once the particular value is selected the macro writes a value category (3 categories, 2 words each) into a specific cell as well as the value short description (15 words max) into an other cell. And, you have a column or range of cells that need to have values from a specific set of values. Step 1: Open a worksheet in Excel 2013. This wikiHow teaches you how to edit an existing drop-down list in a Microsoft Excel spreadsheet. Bottom Line: The complete Excel guide on how to create drop-down lists in cells (data validation lists). First, if you aren't familiar with how to use data validation to add an in-cell drop-down, read my article Create a Drop-Down List in Excel. com October 21, 2015. So there you have it - three different methods to create a drop down list in Excel. Open the General list where you will see the name of the Date Picker control you placed on the worksheet (e. How to create drop down menu or drop down list in excel 2016, 2013, 2010 How to create your own drop-down list/drop-down menu for some particular cell or particular column? Do the following steps:. Now, go out there and be dynamic! Download the Use a Data Validation list to create a quick dynamic Excel chart example file. Two ways to add a drop down list in Excel. To create this dynamic chart in Excel 2007, you can create a table from the chart data, then create named ranges, and use those names in the chart. Note: Dynamic named ranges will not appear in the Name Box dropdown list. Download example workbook: ComboBox_SheetSelector. How to make dependent dropdown lists in Excel See also: Data validation overview | Data validation formulas One of the most useful features of data validation is the ability to create a dropdown list that let users select a value from a predefined list. When applied, the Data Validation function serves to restrict data that can be entered in the target cell, requiring users to select a value from a list of pre-determined inputs. Make a review quiz in Excel and format the cells so that right answer selections are a different color from wrong answer selections. To insert it in your sheet, just do the following: To insert it in your sheet, just do the following: Go to the Developer tab > Controls group, click Insert , and then click the More Controls button under ActiveX Controls. Select the cell in your table where you want these items to show as a drop-down list. Select the Date Drop down and change the date; You will see Cell C5 change to that date; You will see cell D5 (which =C5) change as well. Create a Drop-down List. Usually I open a new sheet, name it something no one would ever consider using (like "far43fq") and print the data there. Enter the list into the cells. To indicate that a drop down list is present, Excel displays a down arrow to the right of the cell. How do we remove the blank cells from the drop down without changing the range of the drop down. com October 21, 2015. You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if you rely on other users. Here's what we are trying to achieve: The user selects Pizza from a drop-down list. Although I'm taking the screenshots using Excel 2016, the steps are the same if you're using an older. The Excel drop-down list is a great tool that belongs to the data validation group. However if you want to add the custom list stored in the workbook to another computer, you can do this with the following steps: Open the Sort dialog box. The Form command button you want to add to the Quick Access toolbar is only available when you click the Commands Not in the Ribbon option on the Choose Commands From drop-down list. The D5 was just to ensure that C5 was actually showing a date. However, when we create a dashboard or a template, we need to create a dependent drop down list or a conditional drop down list in Excel. If you want to include a drop-down list with a long list of options and don't want to type all of them out, create a combo box and choose the first option in the Combo Box Wizard, I want to get the values from another table or query. You can use this Combo Box to create dynamic charts or formulas with Excel. I'm not sure what kind of additional details you need, but I'll throw some information at you anyway. Sometimes you have a sheet that you need other people to fill in. It is about having the understanding of what is linking these lists together. Now you’ll want to click the Data tab in the Ribbon. First, if you aren't familiar with how to use data validation to add an in-cell drop-down, read my article Create a Drop-Down List in Excel. Here is the exact requirement: I have created a drop down menu in excel with three values – Critical, Major and Minor. Alternatively, you can use a named range. For example, I found a way to create a drop down list for the cells in column H using data validation and choosing list type, then specifying the range name, or the cells where valid values exist. Drop-down lists are created using the Data Validation feature. Inserting multiple drop-down lists that is somehow linked together in Excel is very simple. Filling in a DropDown list in Excel is not a frequent requirement in our software development. that value should be able to be selected from a drop down list based on the contents of column B in the second sheet, but also without having to scroll through duplicates. Select the Date Drop down and change the date; You will see Cell C5 change to that date; You will see cell D5 (which =C5) change as well. How to make a drop down list in Excel: First of all open your excel sheet and select the cell on which you wish to create a drop down. Here is a list of order numbers and products. During some advanced Excel training, I was asked how to create a variable drop down list in excel using a data validation list that changes depending on the value in a related cell. If you constantly have to enter in similar data, how much easier would be it if you could just open down a dropdown menu and select the right entry rather than having to type it over and over again?. Select cells C4 through C7 and go to Conditional Formatting –> New Rule… on the Home ribbon. Related Topics. This wikiHow teaches you how to edit an existing drop-down list in a Microsoft Excel spreadsheet. For example, I found a way to create a drop down list for the cells in column H using data validation and choosing list type, then specifying the range name, or the cells where valid values exist. We're going to create a drop-down list with a selection of age ranges to show you how it's done. Each item should reside in its own cell, and be displayed in the same column. I created a drop down list using validation function. The Data Validation drop down list just references the name “Names” as the source of the list: So, each time we modify the list, the COUNTA function will adjust automatically. We are going to create two drop down lists. How do I create a drop down list which has the values from a database column. Users click the drop-down arrow to display a list of items from A1:A4. in a Word document to create a Form Word has this nice feature which enables insertion of text fields, check boxes, drop-down lists, etc. Watch Video. In this post, we'll create two data validation drop-down cells that provide the ability to select From and To dates based on the transaction dates stored in the source data. The drop-down list is a great way to seem like a superuser and impress your co-workers and boss 🙂 At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. example file. This works well with a list of words, but the list doesn't show symbols if you create the list in a font such as Webdings. Conclusion. Most of the code is very. From the resulting menu select the Pick From Drop-down List option. Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel September 11, 2015 by Barbara Adding a drop down list to your Excel sheet is a really great and convenient way to allow data entry to your Excel worksheets whilst maintaining good quality consistent data and reducing the amount of space taken up by lists!. In my earlier post, I have shown you how to create a simple drop down list in Excel. Select the icon on the bottom right hand corner under the ActiveX Controls. This blog explains different methods to export data from Excel to a SharePoint List. Excel Drop Down List – 3 Types of Drop Down Lists – Includes PREMIUM content; How to create Drop Down Lists in Excel – Using Dynamic Ranges; Create a Dependent Drop Down List –. If your list is short, you can avoid Step 1. It’s easy to add a drop-down list to a cell in Excel, but the process is not intuitive. You just have to follow few simple steps. To create a drop-down list of changing entries, simply follow the steps below. As new items are added, the range will automatically expand. How to Create a Drop-Down List in Excel 2010 May 18, 2015 By Matt If you are entering data into a spreadsheet, or if you are creating a spreadsheet for others to use, then it is typically a good idea to make everything as easy as possible. I should get the drop down CALENDER list to pick my date. I often use this feature in dynamic Excel reports to select dates, regions, products, and other settings. Select the cells that contain your list. Make sure the first drop-down list in the Edit the Rule Description area is "Cell Value. This can be handy if you're doing a one off data entry and will allow you to enter some data exactly as it appears in cells above to avoid any typos. Using a mix of Formulas and VBA, it will give you a dynamic search bar where it will show you the relevant matching records as you type. If you need to make Excel 2013 suitable for your work, you can do that by setting this up. Most appreciated if you can help. If you constantly have to enter in similar data, how much easier would be it if you could just open down a dropdown menu and select the right entry rather than having to type it over and over again?. 2) Go to the “Data” tab in the Excel 2013 ribbon. Just follow the steps below in order to learn how to create a Drop Down List in Excel 13. Click on the Allow drop down menu and select List. If I give people a form to enter the data I can validate it and control where it gets added. The first drop down list contains unique distinct values from column A. Open a spreadsheet in Google Sheets. Here’s how it’s done. On the summary page which contains the two lists, when a month is chosen, i'd like that to restrict the cells that the second drop down lists pulls data from so that I can change the months, but still use the same product drop down list, while having update results if that. To enter information in that cell, click the arrow, and then click the entry that you want. How to Edit a Drop Down List in Excel on PC or Mac. A drop-down list is the most convenient way to provide the user an option to select from a pre-defined list. Within this second sheet, we'll write out the list of options the user can choose within the drop-down list. 1) Click on the cell you want the look up / drop down list to appear in. Now I want to create a drop-down list for the City column. A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. You can improve your work efficiently by using a drop-down calendar for data collection. Create drop-down lists in a cell with Google Sheets. Excel Drop Down List - 3 Types of Drop Down Lists - Includes PREMIUM content; How to create Drop Down Lists in Excel - Using Dynamic Ranges; Create a Dependent Drop Down List -. The simplest way to create a drop-down list in Excel 2013/2016 involves listing the choices in a dialog box. Here is a list of order numbers and products. You can also create a drop-down list refer to the data in a worksheet. The functionality comes back if I click on the “Restore down” bottom and then I maximize it. This blog explains different methods to export data from Excel to a SharePoint List. He can choose a specific one. How to add a DROP DOWN CALENDAR to a cell in Excel 2013? I have attempted to use 'MORE CONTROLS' in ACTIVEX CONTROLS but there is no calendar listed. That's easy. There is an added sheet called "Drop Down List". cells A1 to A10). Home / Excel / Data Validation in Excel – Adding Drop-Down Lists in Excel Previous Next We can control the type of data or the values that users can enter into a particular cell or range using Data Validation in Excel. On the second sheet, type the items you want to appear in the drop-down list. But trust me, when someone wants a drop down menu, they won't settle for anything else. My drop down list is below these rows and works exactly as your example referring to a list and a bunch of images in the “reserved” cells. How do I create an excel drop down list with search suggestions in Excel. You can use this Combo Box to create dynamic charts or formulas with Excel. This article shows you how to make a drop down list in excel. In Excel 2011, how do you create a drop down list using data validation where you can select more than one item and have it display in a single cell separated by a comer? It can be done on a windows PC but not sure how to do this on the Mac. How To Create An Excel Drop Down List An Excel drop down list can be created using the Excel data validation options as follows: Enter your allowed values (i. Could it be done that the operator of the sheet types in todays date into say A2 (the date column), and then all subsequent rows of A are a drop down of either todays date or the next two subsequent days?. Download the Use a Data Validation list to create a quick dynamic Excel chart. But trust me, when someone wants a drop down menu, they won't settle for anything else. How to Create a Variable Drop-Down List - Example The spreadsheet below contains a list of members of staff, split into teams. what's the way to do it. In one of them, I want to have a drop-down list whose items are on an Excel File called "ClientList" - in Sheet1, column A. Hi! You have not responded in the last 24 hours. , Name and City columns. We will do this with in-cell data validation lists. Create a Drop-down List. How to allow multiple selections from a dependent drop down list to apply to multiple selections from a data validation drop down in Excel 2013 Excel IT Pro. How to Create Custom AutoFill Lists in Excel 2013; dialog box down to the Import List from Cells text box and puts a marquee (the so-called marching ants) around. In this article, we will learn how to create a Dropdown list with color in Microsoft Excel. Right now, I have to click on the drop down menu and scroll manually until I reach that desired list. Repeat step 1-3 until you are as giddy as a little girl. Click 'OK' to save your changes. Another way to duplicate or move data in Excel is to use drag and drop. in a Word document to create a Form Word has this nice feature which enables insertion of text fields, check boxes, drop-down lists, etc. Column A's validation allow dates, but not in the past. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again. Could it be done that the operator of the sheet types in todays date into say A2 (the date column), and then all subsequent rows of A are a drop down of either todays date or the next two subsequent days?. Using the drop-down list saves lots of time and effort because it’s always easy to select from the list instead of typing in each particular cell man. A dynamic drop down list in Microsoft® Excel® is a convenient way of selecting data without making changes to the source. This feature allows you to create a list of items to choose from, and insert a drop-down selector into any empty cell on your spreadsheet. Is this possible??Thanks!!Molly TechMolly. At the top of the code window there are two drop-down lists, one marked (General) and the other marked (Declarations). This means your drop down list will now contain the values in the range you called “Type”. Drop down menus are quite common while working with Excel. Custom – Enter a custom formula. I used this often as Rows is the default for Series in and I kept forgetting to change it to Columns about every fourth time. To change the font in a cell, select the text that you wish to change the font for. Thankfully Excel offers a very simple solution to create a list that only includes Weekdays. In this example the values from the drop-down list are on the other sheet too — but what if they're not? To find the list that the drop-down menu is using you can look at various guides on how to create dependent drop-down lists, and reverse-engineer those. In Excel 2010 and 2007, a handy feature I use all the time during budget season is the Data Validation feature which allows you to create an in-cell Drop-Down list for populating fields. Do not leave blank rows. Watch our 17 minute video showing how to create drop down menus for dynamic Excel charts and Dashboards. Data Validation feature in Excel allows the user to create a drop down list in Excel. Part 1: Setting up your spreadsheet. Includes keyboard shortcuts to select items, copying drop-downs to other cells, handling invalid inputs, updating lists with new items, and more. Select the HOME tab in the toolbar at the top of the screen and select your new font from the drop-down. A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. I have a Microsoft Excel spreadsheet (2 columns) that I need to use with a PDF. This PDF that I am creating will have a drop-down box that I want to display the data from the Excel spreadsheet. This assumes that the layout is similar to this: A country name is selected from the drop-do. Excel 2013 introduced a Recommended Charts feature that suggests chart types based on the data structure selected. Note: If you can’t click Data Validation, the worksheet might be protected or shared. In Access, you can create a dropdown list. The D5 was just to ensure that C5 was actually showing a date. It provides two ways for you to quickly and easily make dropdown lists in an Excel spreadsheet. The drop down not only shows the entered values in my list but also shows the blank cells which have yet to be populated. With a drop-down list, you can limit your exposure to improper data additions by only giving users a select number of options to pick from. How to Create a Dynamic Chart using a Drop-Down List. How to use date time picker in Microsoft excel 2007, excel 2013 Mohamed Abubkr as shown. Steps to Create a Drop-Down List in MS Excel 2016: Step 1: In the image below you can see that I have prepared an Excel sheet which contains Sr no. Please note: To create a drop down list the file type needs to be. If you need to extend the range showing the drop-down list you can do it two ways. So follow the steps given below: Open a Microsoft Excel Sheet and Enter data in a column or in a row. Alerts About Approaching Due Dates. Add a Drop-Down List to the Selected Cells The Data Validation dialog box displays. How to make an Excel drop-down list Drop-down lists is a feature of Excel that enables you to have users select an option from a predetermined list instead of them typing their own values. Two ways to add a drop down list in Excel. If you want to make a drop down list dependent on another list, try this article from Excel by Joe. This wikiHow teaches you how to edit an existing drop-down list in a Microsoft Excel spreadsheet. This tutorial shows you how to create a calendar in Excel worksheet using the ActiveX Control. You can look up the value that you need in a list making data entry easier and more accurate. In my earlier post, I have shown you how to create a simple drop down list in Excel. For example , I select “C1”. This feature allows you to create a list of items to choose from, and insert a drop-down selector into any empty cell on your spreadsheet. Open the workbook that contains the drop-down list. An Access Student Asks: How do I create a drop down list? Access 2007/2010/2003 Tip. For the first, enter the list in the worksheet as seen above. Today we will learn creating a drop-down list in Excel and we would be using snapshot and menu options from Excel 2007 here. example file. Now, click on Data in the ribbon and select Data validation in the data tools menu. If you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list. We'll show you how to use tables, named ranges, formulas, data validation, and table styles. I should get the drop down CALENDER list to pick my date. thanks a ton. In this article, we will mainly talk about how to implement such a feature. Select the Developer tab. How to use date time picker in Microsoft excel 2007, excel 2013 Mohamed Abubkr as shown. , Name and City columns. Here's what we are trying to achieve: The user selects Pizza from a drop-down list. Click Data Validation in the drop-down list. Conclusion. How to Edit a Dropdown List in Microsoft Excel. My drop down list is below these rows and works exactly as your example referring to a list and a bunch of images in the “reserved” cells. Drag and drop is an elegant alternative to using copy and paste. Filling in a DropDown list in Excel is not a frequent requirement in our software development. If you are unfamiliar with creating drop-down lists in Excel, this post will tell you all there is to know. Drop down lines - number of lines in Combo Box - it should be the number of values in list or less Your Combo Box is ready. Can someone please help me to create a drop-down list using VBA in Excel 2007? I want to have a drop-down list of values (7 in total, 2 words each). How to Create a Single Cell Bulleted List in Excel November 5, 2014 by Carol Bratt 7 Comments You may know that you can enter multiple lines within a single cell by simply clicking Alt + Enter at the end of each line, which starts a new line for you. First, if you aren't familiar with how to use data validation to add an in-cell drop-down, read my article Create a Drop-Down List in Excel. to use date time picker in excel in an easy way. Select the Date Drop down and change the date; You will see Cell C5 change to that date; You will see cell D5 (which =C5) change as well. Excel automatically creates an empty event procedure. in a Word document to create a Form Word has this nice feature which enables insertion of text fields, check boxes, drop-down lists, etc. If you want to make a drop down list dependent on another list, try this article from Excel by Joe. what's the way to do it. How to add a drop-down list in Excel: In order to add an excel drop-down list to a cell, we use the simple technique and will generate it in minutes. Steps to Create a Drop-down List. This is true in all cases and in many pivot tables on one sheet. Excel 2013 introduced a Recommended Charts feature that suggests chart types based on the data structure selected. Create the list in cells A1:A4. Enter the list into the cells. To create a drop down menu in your Excel worksheet: Open your Excel spreadsheet, then select the cell where drop down menu has to be inserted. It is about having the understanding of what is linking these lists together. To use this, select an empty cell directly underneath your data and right click. Change the value. However, the list includes Saturday and Sunday. Within this second sheet, we’ll write out the list of options the user can choose within the drop-down list. In additionally,If you get more issue,I would suggest you open a new thread in this forum,thanks for your understanding. I have a Microsoft Excel spreadsheet (2 columns) that I need to use with a PDF. Watch Video. We are going to create the lists together, and further insert the drop-down list. For this example, we will create a field to be used to store the importance of each task of the project. In the example below, I entered 5, 0, and 6 in cells B2:B4 and formatted the cells with Webdings. This way is through form fields. This is how to do it: Click on the cell which is being used for the drop-down list. Once you create the drop-down list, editing the entries is as easy as changing the cell data. Using a drop-down list for data validation makes data entry easier, prevents data entry errors, and restricts the number of locations for entering data. npoi create cell drop down list in excel 'NPOI Download from here:http://npoi. In our previous article How to Create Drop-down List from a Range of Cells in Your Excel , we have introduced the drop-down list in detail. This will make a massive difference if you have multiple staff working on the same document. Creating Data Validation (Manually): Step1: In the first step you would need to print the data you are going to fill the drop down list with somewhere. I used Excel 2013. Could it be done that the operator of the sheet types in todays date into say A2 (the date column), and then all subsequent rows of A are a drop down of either todays date or the next two subsequent days?.