Hey Chip,

Thank you so much! I inserted the code into my Auto_Open
sub routine, and it worked like a dream!

Yours,
C.M.


-----Original Message-----
Cathy,

Use
=TODAY()
and
=TODAY()-7

If you want to use VBA, use

Range("A1").Value = Format(Now,"mm/dd/yyyy")
and
Range("A2").Value = Format(Now-7,"mm/dd/yyyy")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Cathy Myers" wrote in message
...
Hi,

I am very new to both Excel and VBA. How do I set a cell
to default to today's date, and another cell to default
to
7 days before today?

Thanks,
C.M.


.