0

I'm creating an excel sheet that has a variety of columns, but the one in question is the dates column. 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?

3
  • Sure, e.g. per VBA scripting. Mar 7, 2018 at 13:58
  • @dude what does that mean? lol
    – Joe
    Mar 7, 2018 at 14:29
  • That means that you can try to write a VBA-Macro to achieve your goal and ask for a help if you stuck :) Mar 7, 2018 at 14:31

2 Answers 2

1

You don't need to even fill A1. In B1 enter:

=TODAY()+ROWS($1:1)-1

and copy downwards. Then set the DV for a column A cell to List:

enter image description here

Then copy this cell down the column.

0
0

It can be done by following these steps:

  1. Add another sheet to your workbook to hold the drop down list content.
  2. Create a link on this new sheet to cell A2 in the original sheet.
  3. Use formulas to populate the next two fields on the new sheet with subsequent dates.
  4. Use Data Validation -> Allow List.

Source: should point to the cells on your new Sheet.

2
  • what kind of formulas populate cells with subsequent dates?
    – Joe
    Mar 7, 2018 at 14:29
  • On worksheet 2, if cell A1 contains the link to the date cell on worksheet 1, then in cell A2 put the equation "=A1+1". Excel interprets that as adding 1 day to the referenced date.
    – Eric Peery
    Mar 7, 2018 at 15:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .