EXCEL VBA IF CELL A2:A1000 CONTAINS ANY LETTER OR NUMBER, PUT TODAY'S DATE ON SAME ROW : working on the project at work and tried to search but can't find any answers.

Like the title says, if cell a2 to a1000 contains any letter or number, I would like to input today's date on row E (same row but today's date 4 rows over on column E).  Please see example of what I want picture below.

Thanks in advance.  


[enter image description here][1]


  [1]: https://i.stack.imgur.com/EBP6u.png