Default Date: Today

[Cathy Myers]

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.

 

[Chip Pearson]

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 (e-mail address removed)

 

[Abdul Salam]

Hi,

to get todays date

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

Abdul Salam

 

[Tritan]

range("A1").Value = date
range("A2").Value = date - 7

Tritan

 

[Cathy Myers]

Hi Chip,

Thank you. I will try it and let you know how it turns out.

Yours,
C.M.

 

[Cathy Myers]

Thanks

C.M.

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

to get todays date

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

Abdul Salam



.

 

[Cathy Myers]

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.