How to check if a cell exist

I have an excel spreadsheet that starts with one row and then continues with an additional row each day.
I want to include a formula in this spreadsheet that uses a cell that is weeks old meaning that when I start this spreadsheet that cell does not exist but after several week it does. Is there some sort of “IF” function I can use so that my formula will not work if this cell does not exist?

You are so vague with your question it is difficult to give an answer

You can have spreadsheets that grow as more data is added to them, and you can have formulas that will automatically adjust when the sheets do grow.

Firstly the cell will exist, it may be empty. If the cell is weeks old why will it be added in the future?
Is it a fixed cell eg it will be in A1 or will you be looking in a column to see if the value has been populated.?

A workbook as per the yellow banner will get you a better answer

Agree with what davsth says.
There seem to be tons of way to tackle what you're describing but it depends on the specifics.

On the face of it, it sounds as if you just need some counter or assign a date/time stamp once a cell is populated.
And rather trying to figure out if a cell exists or doesn't (all cells exist in a new workbook), your function should check if the cell has e.g. a value.

If my spreadsheet has one row added per day. How can I have a formula check on a cell 30 days old when I may have only one row. My formula would be be looking for a cell the does not exist for 30 days.

I am sorry but I will not attach my workbook. It is confidential. If you cannot answer with the information
I have already given you, i thank you for trying and will say good by.

I think I am the problem on this request. I forgot to indicate these formulas are part of a Macro using Relative Reference. I started this worksheet well before I started the Macro. So in the Macro I reference a cell that goes back 30 days that works fine for now. But if I wanted to start a new worksheet using my current Macro, the Macro would be referencing cells that do not exist. Is there a way to get around this problem?

Yes there is a way, probably several. but without a spreadhsheet or the macro code it is very hard for people to help you. We do not even know what "these formulas" are! We are all pretty much in the dark

Try a formula similar to this one:

Please Login or Register  to view this content.

Artik

Thank you I will try it