- Dec 13, 2017
- Reaction score
I have Cell G19 with a generic date depending on the month of the worksheet. I.e. 10/1/2000, 11/1/2000,........... I currently have a user that enters the month & day, but not the year. I am trying to change the year automatically when a month & day is entered. Attached are examples of the generic date & changed date. G22, which is below Days until next meeting, requires the entry of a month, day & current year. Is what I ask, possible. I have seen date comparison, but nothing about changing just the year. The dates entered are done in advance, so an entry for January would be entered in December. The January worksheet would show the year for that January.