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"
<SuperDad@discussions.microsoft.com> 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" <SuperDad@discussions.microsoft.com> wrote in message
news:F2B92CF3-7D81-47CC-94FF-C00D1C3A7D40@microsoft.com...
>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" <SuperDad@discussions.microsoft.com> wrote in message
> news:F2B92CF3-7D81-47CC-94FF-C00D1C3A7D40@microsoft.com...
> >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
>
>
>