Moving dates between worksheets
 

I track my bank balance on two worksheets. The first is a date/debit/credit
to track the balance. The second worksheet lists my monthly Standing Orders.
At the start of each month I would like to transfer the coming month's debit
information from the second worksheet to the first. What date format should
I use in the second worksheet, and is it possible to increment by exactly a
month each time. eg how can I write an instruction to debit a regular sum on
say the 8th day of the month?

tks

I wonder if you would save yourself a lot of time by spending $20 or so to buy
Microsoft Money and/or Quicken. It has all of this stuff "built-in", plus lots
more. If you're buying tax software, I see lots of adds for a free copy of
Money or Quicken.

On Mon, 21 Feb 2005 13:49:08 -0800, "SuperDad"
wrote:

I track my bank balance on two worksheets. The first is a date/debit/credit
to track the balance. The second worksheet lists my monthly Standing Orders.
At the start of each month I would like to transfer the coming month's debit
information from the second worksheet to the first. What date format should
I use in the second worksheet, and is it possible to increment by exactly a
month each time. eg how can I write an instruction to debit a regular sum on
say the 8th day of the month?

tks

With the date in A1, in cell A2 enter
=DATE(YEAR(A1),MONTH(A1)+1,8)
Copy down the remainder of the column to set the date to the 8th of each
successive month

--
Regards
Roger Govier
"SuperDad" wrote in message
...
I track my bank balance on two worksheets. The first is a date/debit/credit
to track the balance. The second worksheet lists my monthly Standing
Orders.
At the start of each month I would like to transfer the coming month's
debit
information from the second worksheet to the first. What date format
should
I use in the second worksheet, and is it possible to increment by exactly
a
month each time. eg how can I write an instruction to debit a regular sum
on
say the 8th day of the month?

tks

Roger

That looks promising! I knew it had to be possible! Many tks for yr help

Dave

"Roger Govier" wrote:

With the date in A1, in cell A2 enter
=DATE(YEAR(A1),MONTH(A1)+1,8)
Copy down the remainder of the column to set the date to the 8th of each
successive month

--
Regards
Roger Govier
"SuperDad" wrote in message
...
I track my bank balance on two worksheets. The first is a date/debit/credit
to track the balance. The second worksheet lists my monthly Standing
Orders.
At the start of each month I would like to transfer the coming month's
debit
information from the second worksheet to the first. What date format
should
I use in the second worksheet, and is it possible to increment by exactly
a
month each time. eg how can I write an instruction to debit a regular sum
on
say the 8th day of the month?

tks