|You can't use that formula in H20 because it references H20. That is going to cause a circular reference. You are asking Excel to produce a value in a cell based on the value in the cell itself. For obvious reasons, Excel can't do that.|
A circular reference will sometimes return a 0 value. If the cell is formatted as a date, then the cell will return 1/0/1900 since that is the first day of the Excel calendar.
BTW...you may not realize that you have a Circular Reference because Excel will only tell you once. Once you clear the first Circular Reference warning, you can enter formulas with circular references all day long and Excel will never warn you again until you close and reopen the workbook.
I'm not 100% sure what you are trying to do, but I know that you can not use that formula in H20.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.