Excel 2007 : Incorrect Circular Reference with TODAY function

EDIT: Moved posts to new thread.
----------------------------------
I'm having the same problem. Excel is saying that this formula is circular, but it isn't. (Reference to thread: http://www.excelforum.com/excel-2007...-function.html)

Cell AA3 is:

=IF(AA2="","",IF(AND(((TODAY()-AA2))>20,((TODAY()-AA2))<29),1,""))

AA2 was originally a formula too, but just to prove excel is crazy, i changed it to an integer and excel is still calling the above circular. Am i missing something, or do should i reinstall excel too?

Hi Erikmalk,

Welcome to the forum.

After changing AA2 to integer, the issues should have been resolved.. check if you still have some other circular references in some other cells, else post the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Originally Posted by Erikmalk

I'm having the same problem. Excel is saying that this formula is circular, but it isn't.

Cell AA3 is:

=IF(AA2="","",IF(AND(((TODAY()-AA2))>20,((TODAY()-AA2))<29),1,""))

AA2 was originally a formula too, but just to prove excel is crazy, i changed it to an integer and excel is still calling the above circular. Am i missing something, or do should i reinstall excel too?

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Sometimes, where Excel says the circular ref is, is not really where it is. Oftentimes, the "accused" cell is the result of preceeding formulas that are creating a circ ref, so sometimes the search for the culprit has to go backwards from where it says the circ ref is

I agree with FDibbins...

Regards,
DILIPandey

<click on below 'star' if this helps>

I will take a look at your file as soon as a sumproduct formula i was working with, lets me have excle back. quick tip...NEVER use entire column ranges in a sumproduct calc LOL

ok that file contained 1 sheet, with data in 2 cells - A1 had a date in it, B1 had =IF(A1="","",IF(AND(((TODAY()-A1))>13,((TODAY()-A1))<21),1,"")).

It does not show a circ ref, so maybe when you deleted the other stuff to send that, the circ was somewhere in what you deleted?

KenKeefe, welcome to the forum

Not sure if you noticed, but this thread is over 2 years old, I doubt it is stll being monitored, but thanks for the input

Not a problem, I have done the same thing myself
(I went from Supercalc to 1-2-3 to excel)