Excel formula...
 

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.

Excel formula...
 

Enter the below formula in cell B2
=A2+80

and select the cell B2. Double click the fill handle (bottom right) of the
selection rectangle.

--
Jacob


"CM" wrote:

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.

Excel formula...
 

Thanks for the help and quick reply.

"Jacob Skaria" wrote:

Enter the below formula in cell B2
=A2+80

and select the cell B2. Double click the fill handle (bottom right) of the
selection rectangle.

--
Jacob


"CM" wrote:

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.

Excel formula...
 

I entered a formula in C1 that is =A1*B1. I want to fill down 20 rows so
that the formula becomes =a2*b2, =a3*b3 and so on. The fill down comand and
also the copy paste comand copies the formula but the result stays the same
as C1 for all rows. Then when I click in the formula bar and hit enter the
correct result appears.
How can I get the fill down or copy paste to work properly?

"CM" wrote:

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.

Excel formula...
 

Make sure you have excel's calculation mode set to automatic.

In xl2003 menus:
tools|options|calculation tab

It's hidden under the Office button|excel options in xl2007.

Lewis wrote:

I entered a formula in C1 that is =A1*B1. I want to fill down 20 rows so
that the formula becomes =a2*b2, =a3*b3 and so on. The fill down comand and
also the copy paste comand copies the formula but the result stays the same
as C1 for all rows. Then when I click in the formula bar and hit enter the
correct result appears.
How can I get the fill down or copy paste to work properly?

"CM" wrote:

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.

--

Dave Peterson

Excel formula...
 

Tools/ Options/ Calculation
Set to Automatic, not Manual.
--
David Biddulph

"Lewis" wrote in message
...
I entered a formula in C1 that is =A1*B1. I want to fill down 20 rows so
that the formula becomes =a2*b2, =a3*b3 and so on. The fill down comand
and
also the copy paste comand copies the formula but the result stays the
same
as C1 for all rows. Then when I click in the formula bar and hit enter
the
correct result appears.
How can I get the fill down or copy paste to work properly?

"CM" wrote:

I am entering dates into column A and in Column B i would like to add 80
days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply
to
entire column of B for each date that is entered in Col A.

Excel formula...
 

ButtonExcel OptionsFormulas will unhide the calculation options.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 16:46:12 -0600, Dave Peterson
wrote:

Make sure you have excel's calculation mode set to automatic.

In xl2003 menus:
tools|options|calculation tab

It's hidden under the Office button|excel options in xl2007.

Lewis wrote:

I entered a formula in C1 that is =A1*B1. I want to fill down 20 rows so
that the formula becomes =a2*b2, =a3*b3 and so on. The fill down comand and
also the copy paste comand copies the formula but the result stays the same
as C1 for all rows. Then when I click in the formula bar and hit enter the
correct result appears.
How can I get the fill down or copy paste to work properly?

"CM" wrote:

I am entering dates into column A and in Column B i would like to add 80 days
to each cell in Col. A to create the new date in Col. B... I can do
individually with i.e. A2+80 in the cell for B2 but I would like to apply to
entire column of B for each date that is entered in Col A.