View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Cathy Myers Cathy Myers is offline
external usenet poster
 
Posts: 9
Default Default Date: Today

Thanks

C.M.

-----Original Message-----
Hi,

to get todays date

= TODAY()
7 days before today
=TODAY()-7

Abdul Salam



-----Original 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.
.

.