Excel Macro to take actions based on date in certain columns = today

Job ID: 35606339

Budget: $30 – $250 USD

If a date in Column(X)=TODAY(), then the cell immediately to the right of that cell with the date, will have the following actions:
Copy 
Paste Special(Values) 

[The copy and Paste Special(Values) will be done on the cell to the right of the cell with today's date).
Related categories: Visual Basic Excel