Hi Martin

If you had weekly dates running down column A, and your amounts in column B
and column C, you could use in B2
=IF($A2<=TODAY(),100,"")
where 100 represents the income
Do the same for C2 with the relevant amount for that column.
Copy both formulae down for as many rows as you have dates in column A.

When today's date exceeds or equals the weekly date, the amounts will
appear.
--
Regards
Roger Govier

"Martin ©¿©¬ @nohere.net" wrote in message
...
Hi
I have created a small spreadsheet for a post office account which has
a regular income twice a week
Is it possible to create a formula that will automatically input these
amounts every week - and if so, how do I do it?

Using Excel 2003 on Vista
--
Martin
©¿©¬