Update cell based on date range - noob question

  • Thread starter Thread starter deversole
  • Start date Start date
D

deversole

Hey guys! I was wondering if I could get some help here. I would lik
to update a cell based on a date range. For example, I would like t
update the value of a cell to the value of another cell if the curren
date is between July 1st and July 10th. However, if the date i
outside the date range, I want the value for that cell to not b
updated, and be the previous value. Can anyone give me an example a
to how I would do this? Thanks!!
 
This is the function that I am trying to get to work:

=IF(AND(TODAY()>G37,TODAY()<H37,WEEKDAY(TODAY())=3),'Status'!D59,????)

What I want to do is update a cell for that week on that Wednesday. I
will have a cell for each week, and each Wednesday that cell will be
updated with another value, which is at 'Status'!D59. However, I don't
want that particular cell updated if it is not during that week. So, if
that cell is updated in one week, I don't want that value to change the
following week from what it was the previous week. Does that make
sense?
 
I think I'd use multiple cells.

For instance:

A1 can contain the original value
B1 can contain the value that the user types in
C1 can contain this formula:

=if(and(date(2005,7,1)<=today(),today()<=date(2005,7,10)),b1,a1)
 
Thanks for the reply Dave. Did you read my second post? It may hel
explain my problem a little better
 
You've got a couple of threads going.

I'd use multiple cells. A cell can contain a formula or a value. If you
overwrite the formula, it'll be lost forever.
 
Thanks again Dave. I do understand that cells can either contain
formulas or values. However, I do not intend to type the values into
the cell. That is the reason for the formula, so that it will
automatically be updated every Wednesday. I am unable to use multiple
cells to determine the value. I am helping out on some project
metrics, and am unable to change it much. Isn't there some kind of
command that will cause certain cells to not be updated when a certain
criteria is not met?
 
It sounded to me like the first time you know that the cell should not be
updated is after it's been changed.

I don't know a way to do that using formulas and no extra cells.
 
OK, thanks for taking the time to help anyways Dave.

Hrmm...there has got to be a way to do this..
 
Back
Top