i have a macro that saves my workbook as "workbook - " and the current date retrieved by a cell. that works fine. i have another that clears all the cells in a given range. this works fine.

my problem is, when i clear the cells, i want the macro to add 7 to the cell where i retrieve the date. is is possible to add to a cell programmatically?
and also, i need the "saving" macro to only "Save As" when a file of the same name "workbook - (current date)" does not exist.

any help?