Forum Discussion
Solved
How to populate name in cell on excel calendar when date entered on sheet
Is there a way to auto-populate the name from a column on an excel sheet into the corresponding date on the excel calendar based on the date entered in a different column on the sheet? For example, o...
See the attached demo workbook. I didn't create a full calendar, but the formulas used on the January sheet should give you an idea.
See the attached demo workbook. I didn't create a full calendar, but the formulas used on the January sheet should give you an idea.
HansVogelaar thank you so much! I collaborated with a coworker this morning and we were able to find this same type of formula on the web. I am saving your version in my notes to use for later!