Moving dates between worksheets

[Guest]

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

 

[Myrna Larson]

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.

 

[Roger Govier]

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

 

[Guest]

Roger

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

Dave