Click on Tools, Options, Select the Edit tab, make sure that the option to
extend Formats and Formulas is ticked, and it will work, that is, if you type
in the dates. If you use a calender add in, it does not extend. What you
can do then is to move to where you want the formula pasted, and press
<Ctrl<D to copy the formula down. Iow, if your last row is A4:B4, and you
now insert a date in A5, then go to B5, and press <Ctrl<D

"rgb" wrote:

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