I would like to have some formulas added to the end of a worksheet when the
user enters a new row of data. How can I implement this?

Example:
Column A contains a date
Column B contains the Weekday Function

A B
1 12/1/2006 =Weekday(A1) Display value in B1 is 6
2 12/2/2006 =Weekday(A2) Display value in B2 is 7


When the user adds a new date to row 3, I would like Column B to
automatically contain =Weekday(A3) without having to use copy and paste.

Any help is appreciated very much.
--
rgb