Forum Discussion
epyon
Feb 11, 2026Occasional Reader
Validating & Populating Cells with dates based on a Date Picker
Hello, we are working on a really simple delivery schedule for Monday thru Friday. The top row has a cell that is formatted as a short date picker. In choosing a date in that cell, I would like the dates of the 5 numbered cells below for each day of that week to be updated based on the date chosen. For instance, I chose 2/1/26 in the date picker. I would like cells A2, H2, O2, V2, and AC2 to correlate to that date number and automatically populate the proper day of the month. If possible, it would be great if the month names that are in cells D3, K3, R3, Y3, and AF3 would also correlate and update properly.
Any help would be most appreciated, I attached a screenshot to show the layout.
Thank you very much in advance.
No RepliesBe the first to reply