Macro to add column with date that doesn't automatically update.

I have been assigned a task of adding a button(macro) that adds a column on a sheet with todays date on it.  Which I have so far accomplished, but I need to not update all the field previously generated along with the new column being generated.  The macro is activated by hitting the insert day button and works.  I just need it to keep the date cell "static" to when the button was pushed.   Thanks