Formulas not copying to other cells

L

Lance Hebert

I have a spreadsheet in which there are two cells with date ranges based on
=TODAY() (ie. there is one column based on =TODAY()-62 and one based on
=TODAY()-58). I have copied the formula by dragging the formatting to all of
the cells below the first line that I entered the formula in. Well now, the
formulas are working by showing the dates based on the results, but I change
the information on the line or insert a new line in the list, the formulas
are not calculating. Again, the formulas are showing the correct dates, but
the formulas are not showing up in the cells, thus when I enter new
information or line, the formulas are not calcuating.

I have checked that the sheet will automatically calculate, but it is still
not working. Any suggestions? This may be an easy fix and I may be making
this more difficult for me than it needs to be. Thanks for your help.
 
D

dlw

This is a little confusing- the formulas are showing the correct date, the
formulas are not showing up in the cells, and the formulas are not
calculating.

When you copy the original formula, what shows up in the cells that you
copied it to?
 
F

FSt1

hi
i think you may have a slight misunderstanding about the Today() function.
=today()-62 will not change until tommorrow no matter how much data you type
into other cells. the only way you might be able to get the formula to change
is to change it to ..say.. =Today()-A1 then plug different numbers in A1 to
subtract from today().

or did i miss something????

Regards
FSt1
 
L

Lance Hebert

I know this is confusing and I have tried to make it clear, but seems as if I
have failed at that.

DLW: When I copy the formula into other cells the result displays, but if I
change information line that in effect changes the date that is part of the
formula, the result does not change. The result does not recalculate and so I
have to reenter the formula in order for the result to update based on the
new information.

FST1: I do understand the =Today() function. I misunderstood my own
thinking. What I have is a date range based on a "Due Date" column and when I
copy the formula for these two date columns (date range), the formula works
and displays correctly, but if I change a "due date", the formula does not
recalculate. I have to reenter the formula to recalculate.

I hope this clarifies it. Thank you both for your help.
 
L

Lance Hebert

Column C is date such as 3/20/2009
Column D formula is: =C2-62 (equaling 1/17/2009)
Column E formula is: =C2-58 (equaling 1/21/2009)
 
N

Niek Otten

And if you change C2, D2 doesn't change? It should.
Check the setting for Automatic calculation once more: it changes if you
first load another workbook with another setting.
Try CTRL+ALT+SHIFT+F9 too (rebuild the dependency tree)
 
L

Lance Hebert

Niek, I tried all of those things numerous times before posting my original
message. I was hoping that worked, but it still does not work. Any other
suggestions?

Another note, would there be anything that if I enter the formula as
"=C2-68" or "=(C2-68)" that that may be creating an issue with this?

Thanks again for your help.
 
L

Lance Hebert

Thinking more about this, can a "IF" function be applied to these cells?

If I have a column with a due date (column F) and another column (column E)
with a code in it. If the code is one thing (ie. "MU") than the date in
column G should be F-62 and if it is ("MM") it should be F-47. Would the
function look something like this:
=IF(E=MU,[F-62],[F-47])

Help with this function?
 
N

Niek Otten

=IF(E2="MU",F2-62,F2-47)

But something else must be wrong if the cells don't calculate

--
Kind regards,

Niek Otten
Microsoft MVP - Excel




Lance Hebert said:
Thinking more about this, can a "IF" function be applied to these cells?

If I have a column with a due date (column F) and another column (column
E)
with a code in it. If the code is one thing (ie. "MU") than the date in
column G should be F-62 and if it is ("MM") it should be F-47. Would the
function look something like this:
=IF(E=MU,[F-62],[F-47])

Help with this function?


Lance Hebert said:
Niek, I tried all of those things numerous times before posting my
original
message. I was hoping that worked, but it still does not work. Any other
suggestions?

Another note, would there be anything that if I enter the formula as
"=C2-68" or "=(C2-68)" that that may be creating an issue with this?

Thanks again for your help.
 
L

Lance Hebert

That did it!! Thanks Niek. It should update now. I did not think about it
until now. Thanks again!!

Niek Otten said:
=IF(E2="MU",F2-62,F2-47)

But something else must be wrong if the cells don't calculate

--
Kind regards,

Niek Otten
Microsoft MVP - Excel




Lance Hebert said:
Thinking more about this, can a "IF" function be applied to these cells?

If I have a column with a due date (column F) and another column (column
E)
with a code in it. If the code is one thing (ie. "MU") than the date in
column G should be F-62 and if it is ("MM") it should be F-47. Would the
function look something like this:
=IF(E=MU,[F-62],[F-47])

Help with this function?


Lance Hebert said:
Niek, I tried all of those things numerous times before posting my
original
message. I was hoping that worked, but it still does not work. Any other
suggestions?

Another note, would there be anything that if I enter the formula as
"=C2-68" or "=(C2-68)" that that may be creating an issue with this?

Thanks again for your help.

:

And if you change C2, D2 doesn't change? It should.
Check the setting for Automatic calculation once more: it changes if
you
first load another workbook with another setting.
Try CTRL+ALT+SHIFT+F9 too (rebuild the dependency tree)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Column C is date such as 3/20/2009
Column D formula is: =C2-62 (equaling 1/17/2009)
Column E formula is: =C2-58 (equaling 1/21/2009)

:

So, what IS your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

message
I know this is confusing and I have tried to make it clear, but
seems as
if
I
have failed at that.

DLW: When I copy the formula into other cells the result displays,
but
if
I
change information line that in effect changes the date that is
part of
the
formula, the result does not change. The result does not
recalculate
and
so I
have to reenter the formula in order for the result to update
based on
the
new information.

FST1: I do understand the =Today() function. I misunderstood my
own
thinking. What I have is a date range based on a "Due Date" column
and
when I
copy the formula for these two date columns (date range), the
formula
works
and displays correctly, but if I change a "due date", the formula
does
not
recalculate. I have to reenter the formula to recalculate.

I hope this clarifies it. Thank you both for your help.

:

hi
i think you may have a slight misunderstanding about the Today()
function.
=today()-62 will not change until tommorrow no matter how much
data
you
type
into other cells. the only way you might be able to get the
formula to
change
is to change it to ..say.. =Today()-A1 then plug different
numbers in
A1
to
subtract from today().

or did i miss something????

Regards
FSt1


:

I have a spreadsheet in which there are two cells with date
ranges
based on
=TODAY() (ie. there is one column based on =TODAY()-62 and one
based
on
=TODAY()-58). I have copied the formula by dragging the
formatting
to
all of
the cells below the first line that I entered the formula in.
Well
now,
the
formulas are working by showing the dates based on the results,
but
I
change
the information on the line or insert a new line in the list,
the
formulas
are not calculating. Again, the formulas are showing the
correct
dates,
but
the formulas are not showing up in the cells, thus when I enter
new
information or line, the formulas are not calcuating.

I have checked that the sheet will automatically calculate, but
it
is
still
not working. Any suggestions? This may be an easy fix and I may
be
making
this more difficult for me than it needs to be. Thanks for your
help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top