I want to have date pick from drop down boxes

Asked By madmoore 10 points N/A Posted on - 05/02/2013

I am creating a table and I will need a date picker that will show the Year, Day and Month info. I want to have the date pick from drop down boxes too if possible and  I want it to auto-populate the number of days for the current month selected.

• Status: Open
• Question Views: 729
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Dennis Zeman 0 points N/A #130344

I want to have date pick from drop down boxes

Hi Madmoore

Doing this task you would need to use the following feature in Excel 2009 or 2010

• The formula Today()
• Validation Feature of Excel 
• And simple subtraction Formula

Steps

1. You need to select one cell in excel that you would insert the formula "TODAY()" this will automatically get the current date based on your computer calendar. 
2. Making the DROP DOWN BOX.
   1. Right now you need to type in all the days on that  on the current year example 1/1/2013. (After typing the first day of the year just drag it down until you reach 12/31/2013) You can put this anywhere on your Excel sheet.
   2. Highlight On the Right side of the CELL that has formula "TODAY()" then go to >DATA>DATA VALIDATION. You will see a pop up menu. Under Allow option select LIST.
   3.  On the source click the button on the right side of Source then highlight ALL THE DAY THAT YOU CREATED and Press OK
   4. 
3. After this you just need to do simple subtraction Current Day Cell  – Pick a Day Cell 

Hope this was helpful

 

Thanks!

About Dennis Zeman

Questions
1

Answers
9

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 05/08/2013
• Question Category: MS Excel