| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to add 100 years to a cell's date
I am using Office 2003. I know how to write a formula in a new cell and set
it equal to a different cell's date plus 100 years. I can then copy new formula and paste special to original cell. But I sure can't figure out how to do this with a macro. I am thinking I declare a variable as myDate, set myDate = Cell(A1), then add 100 years to myDate, then pastespecial to cell(a1). But I can't get this to work. Any help would be greatly appreciated. -- Bill W |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calc. an anniversary date(50 years) after marriage date in excel | Excel Worksheet Functions | |||
| Display another Cell's DATE value Here | Excel Discussion (Misc queries) | |||
| How do I subtract a date from a date for a sum of total years? | Excel Discussion (Misc queries) | |||
| How do I make a cell's contents equal to another cell's contents with macro program? | Excel Programming | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
Threaded Mode
