Pre-chosen date based upon name chosen
Is it possible to set template date(s) in a group of cells when another cell drop down is selected?
For instance, If I choose from a drop down "June 2024" the dates cells next to this would snap to certain dates (milestones) automatically. Trying to have x4 milestone dates snap when a "Month Year" is selected.
Can anyone help?
Many thanks in advance.
Help Article Resources
Check out the Formula Handbook template!