Update cell based on date range - noob question

Hey guys! I was wondering if I could get some help here. I would like to update a cell based on a date range. For example, I would like to update the value of a cell to the value of another cell if the current date is between July 1st and July 10th. However, if the date is outside the date range, I want the value for that cell to not be updated, and be the previous value. Can anyone give me an example as 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)

deversole wrote:
>
> Hey guys! I was wondering if I could get some help here. I would like
> to update a cell based on a date range. For example, I would like to
> update the value of a cell to the value of another cell if the current
> date is between July 1st and July 10th. However, if the date is
> outside the date range, I want the value for that cell to not be
> updated, and be the previous value. Can anyone give me an example as
> to how I would do this? Thanks!!!
>
> --
> deversole
> ------------------------------------------------------------------------
> deversole's Profile: http://www.excelforum.com/member.php...o&userid=22672
> View this thread: http://www.excelforum.com/showthread...hreadid=384542

--

Dave Peterson

Thanks for the reply Dave. Did you read my second post? It may help 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.

deversole wrote:
>
> Thanks for the reply Dave. Did you read my second post? It may help
> explain my problem a little better.
>
> --
> deversole
> ------------------------------------------------------------------------
> deversole's Profile: http://www.excelforum.com/member.php...o&userid=22672
> View this thread: http://www.excelforum.com/showthread...hreadid=384542

--

Dave Peterson

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.



deversole wrote:
>
> 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?
>
> --
> deversole
> ------------------------------------------------------------------------
> deversole's Profile: http://www.excelforum.com/member.php...o&userid=22672
> View this thread: http://www.excelforum.com/showthread...hreadid=384542

--

Dave Peterson

OK, thanks for taking the time to help anyways Dave.

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