Bob,

Tried your code but still can't seem to get the field to fill in correctly.
I actually had a completely different cell's info change to the date but it
still updated automatically with the current day after I changed the date in
my calendar.