Date

cristyb · May 16th, 2002, 03:44 PM

Is there a way to write a macro that automatically adds 7 days to a date everytime. Ex. 5/19/02 - when I hit my command would make the date 5/26/02?

bergy · May 16th, 2002, 04:02 PM

Quote:

On 2002-05-16 14:44, cristyb wrote:
Is there a way to write a macro that automatically adds 7 days to a date everytime. Ex. 5/19/02 - when I hit my command would make the date 5/26/02?

Is the date located in a specific cell or anywhere on the spreadsheet?

xl · May 16th, 2002, 04:03 PM

range("a1").value = range("a1").value + 7

Yogi Anand · May 16th, 2002, 04:08 PM

Quote:

On 2002-05-16 14:44, cristyb wrote:
Is there a way to write a macro that automatically adds 7 days to a date everytime. Ex. 5/19/02 - when I hit my command would make the date 5/26/02?

If active cell has a date in it, then use
ActiveCell.FormulaR1C1 = ActiveCell.Formula + 7

adjust the cell references as you need.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 03:44 PM	#1
cristyb New Member Join Date: May 2002 Posts: 1	Is there a way to write a macro that automatically adds 7 days to a date everytime. Ex. 5/19/02 - when I hit my command would make the date 5/26/02?

May 16th, 2002, 04:03 PM	#3
xl New Member Join Date: May 2002 Posts: 10	range("a1").value = range("a1").value + 7