Is It Possible To Add Working Days Calendar As A Drop Down In Excel 2016. However, not so many Excel users know the Source field of the Data Validation dialog is a formula field. I am not a wiz when it comes to codes and am not very trusting when it comes to adding things I did a workaround by adding a drop-down list, but this is not ideal.
So you want to create a drop down calendar in Excel?
How to Conditionally Formatting A Drop Down List.
How can I create a pick calendar? Click to view our free tutorial. You can add or remove items from a drop-down list in Excel without opening the 'Data Validation' dialog box and changing the range reference.