Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Date: Today
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Date: Today
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Date: Today
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Date: Today
range("A1").Value = date
range("A2").Value = date - 7 Tritan -----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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Date: Today
Hi Chip,
Thank you. I will try it and let you know how it turns out. 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. . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Date: Today
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date in excel from today to original date of file | Excel Discussion (Misc queries) | |||
Date Formula for number of days between a date and today | Excel Discussion (Misc queries) | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions |