PDA

View Full Version : dates in columns



stefan0901
05-07-2009, 02:47 AM
hey,

I have a date in one cell (eg. "17/01/2006" in cell "D2") and I try to make a macro which creates subsequent dates in cells under the starting cell (here "D2"). For my example, my macro should create "18/01/2006" in cell "D3". Then, I also want my macro to the same but for monthly and yearly data. Again, for my example, the macro should give "17/02/2006" and "18/01/2007" respectively in cell "D3". I tried to make it myself, but it's not working.

Thanks

Bob Phillips
05-07-2009, 03:36 AM
Why 18/01/2007, why not 17/02/2007?

Is a formula okay, or must it be VBA?

How do you determine if monthly, or yearly?

mdmackillop
05-07-2009, 10:25 AM
Look at Edit/Fill/Series. This may do what you are after.