Date calculations in Excel
 

Hi
I am a very basic Excel user and I'm trying to set up a formula that will
calculate a date based on me providing a "Due Date" and a "Number of Days
Prior Item is Due". I also want to be able to change these fields and have
the formula recalculate the date.

For example, in column A1, my Due Date is:
April 4, 2008
In column B1, my "Number of Days Prior Item is Due". I used 60 to represent
60 days prior.
In column C1, I entered the formula:
=A1-B1

I formatted column C to Date and the format I wanted - and it worked. The
value in the cell was Monday February 4, 2008.
However - if I change either the Due date (Column A) or the Number of Days
Prior Item is Due (Column B), the date in column C doesn't recalculate. Is
there a formula I could use in Column C that would allow it to recalculate if
I change a value in either Column A or Column B?

Also, when I copy this formula in column C to the rows below - it copies the
answer from Row 1 regardless of the values I use in the adjacent cells on the
rows below. Is there something that I can do to copy the correct formula to
rows below?

Thank you so much!

--
Lynda

Date calculations in Excel
 

"Lynda" wrote in message
...
Hi
I am a very basic Excel user and I'm trying to set up a formula that will
calculate a date based on me providing a "Due Date" and a "Number of Days
Prior Item is Due". I also want to be able to change these fields and
have
the formula recalculate the date.

For example, in column A1, my Due Date is:
April 4, 2008
In column B1, my "Number of Days Prior Item is Due". I used 60 to
represent
60 days prior.
In column C1, I entered the formula:
=A1-B1

I formatted column C to Date and the format I wanted - and it worked. The
value in the cell was Monday February 4, 2008.
However - if I change either the Due date (Column A) or the Number of Days
Prior Item is Due (Column B), the date in column C doesn't recalculate.
Is
there a formula I could use in Column C that would allow it to recalculate
if
I change a value in either Column A or Column B?

Also, when I copy this formula in column C to the rows below - it copies
the
answer from Row 1 regardless of the values I use in the adjacent cells on
the
rows below. Is there something that I can do to copy the correct formula
to
rows below?

Thank you so much!

--
Lynda

Everything you have done seems correct. Both your formula in C1 and copied
down versions work for me when you change the contents of cells in column A
or column B.

Do you have calculation set to manual or automatic? Look in
Tools Options Calculation tab
and set it to automatic.

Date calculations in Excel
 

Stephen - thank you so much!!! It worked.
--
Lynda


"Stephen" wrote:

"Lynda" wrote in message
...
Hi
I am a very basic Excel user and I'm trying to set up a formula that will
calculate a date based on me providing a "Due Date" and a "Number of Days
Prior Item is Due". I also want to be able to change these fields and
have
the formula recalculate the date.

For example, in column A1, my Due Date is:
April 4, 2008
In column B1, my "Number of Days Prior Item is Due". I used 60 to
represent
60 days prior.
In column C1, I entered the formula:
=A1-B1

I formatted column C to Date and the format I wanted - and it worked. The
value in the cell was Monday February 4, 2008.
However - if I change either the Due date (Column A) or the Number of Days
Prior Item is Due (Column B), the date in column C doesn't recalculate.
Is
there a formula I could use in Column C that would allow it to recalculate
if
I change a value in either Column A or Column B?

Also, when I copy this formula in column C to the rows below - it copies
the
answer from Row 1 regardless of the values I use in the adjacent cells on
the
rows below. Is there something that I can do to copy the correct formula
to
rows below?

Thank you so much!

--
Lynda

Everything you have done seems correct. Both your formula in C1 and copied
down versions work for me when you change the contents of cells in column A
or column B.

Do you have calculation set to manual or automatic? Look in
Tools Options Calculation tab
and set it to automatic.