can you explain to me how your vba is different other than layout?
The biggest difference is I am using the "Worksheet_Change" event. That only runs when a cell is manually updated.
Your code uses the "Worksheet_SelectionChange" event, which runs whenever a cell is selected, regardless of whether or not any update is made.
is it still producing a text output? or is it a valid date like you mentioned earlier?
No, mine produces a valid date. Note how I am applying a number format to the cell. Cell formatting can only be applied to valid number/date entries. It does not work on text entries.
What made your result text was the use of the FORMAT function. The FORMAT function in VBA returns a Text entry.
and i dont want the whole column to update, only the adjacent cell
And that is exactly what it does. Note that the "Worksheet_Change" and "Worksheet_SelectionChange" have "Target" parameters. This is the range which "fires" the event.
In "Worksheet_Change", it is the range that is manually updated. Most often, it is a single cell, but could be a multi-cell range if you used copy/paste to paste to a multi-cell range.
In "Worksheet_SelectionChange", it is the range that is selected (which could also be one or more cells).
When I am looping through the cells in my code, I am NOT looping through the entire column. I am simply looping through all the cells in column E that were JUST manually updated.
And then it is updating column D of that particular updated row(s).
Hope that helps to clear things up.
Let me know if you have any other questions.