#Name Error when using Dates

September 29, 2016 at 11:19:16
Specs: Windows 64
Back -


AT5 is a Date. What I would like for Excel to do is add 5 days to the date in AT5 but I keep getting this nasty #NAME error?

See More: #Name Error when using Dates

Reply ↓  Report •

September 29, 2016 at 11:50:53
Seems to be functioning properly when I test it. How are the cells formatted? How is the date entered in AT5?

message edited by beachyhbt

Reply ↓  Report •

September 29, 2016 at 12:18:04
Short date (ie 10/1/2016)

Reply ↓  Report •

September 29, 2016 at 16:25:27
The formula works for me as well. Is the Destination Cell formatted the same as the source cell?

Doing the best I can here... And remember, there's always more than one path to success. :)

message edited by Jennifer SUMN

Reply ↓  Report •

Related Solutions

September 29, 2016 at 18:40:15
Works for me too.

Select the cell with your formula and then try the Evaluate Formula feature on the Formulas tab. That should allow you to Single Step through your formula to see what part is causing the #NAME error.

For example, I can force a #NAME error with this formula:


When I use the Evaluate Formula feature, I can click Evaluate until I see:


That tells me that the AT is causing the #NAME? error.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Reply ↓  Report •

September 30, 2016 at 12:32:51
I don't know what the issue is here - I tried the evaluation formula function and got this:

IF(FALSE,#N/A,""+5) but unfortunately, I dont know what tis means.

One thing I do want to add that I believe may be important - there's a formula embedded in AT5, does that matter? Is it possible Excel is reading this formula and now the cell is not considered blank?

Reply ↓  Report •

September 30, 2016 at 13:24:09
Typically "" means the cell is empty. Not 0, but empty.

What is the next result if you click Evaluate one more time?

What is the formula in AT5 and what are its dependents such that the formula in AT5 evaluates to ""?

If I force AT5 to return "", I get a #VALUE! error, not #NAME!

e.g. if I put the following formula in AT5 with AT1 empty, AT5 will reslove to ""


If I then use the Formula Evaluator on your original formula I get what you got:


However, one more evaluation step shows


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Reply ↓  Report •

October 6, 2016 at 12:14:29
So, AT5 contains a formula? You said in your first post that AT5 contains a date and then in Post 2 you gave the formatting.

What exactly is in Cell AT5?

Reply ↓  Report •

Ask Question