Have entered this formula:



=IF(ISNUMBER([@[Final Due Date for New Apps]), DATE(YEAR([@[Final Due Date for New Apps])+1, MONTH([@[Final Due Date for New Apps]), DAY([@[Final Due Date for New Apps])), IF(ISNUMBER([@[Initial App Due Date]), DATE(YEAR([@[Initial App Due Date])+1, MONTH([@[Initial App Due Date]), DAY([@[Initial App Due Date])),""))

Purpose:
Look in column for Final Due Date for New Apps. If there is a number, add one year and enter in Funding Deadline column. If not, look in column for Initial App Due Date, add 1 year and enter that date in Funding Deadline column. If no date appears in either column, return "".

Getting this syntax error:

Verify that the name:
-Starts with letter or underscore
-Doesn't include a space or character that isn't allowed
-Doesn't conflict with an existing name in the workbook

I don't believe I've violated any of the above.

The second parenthesis is red, which I interpret to mean there's an issue with the placement or number of parentheses. I've counted and there are equal left and right facing parentheses, not sure if I have them all in the right place, or if it another issue altogether.

Thanks.

Parens look good but shouldn't brackets also be paired? A bracket in front of each @ looks odd to me.

Must be e.g. '[@[Final Due Date for New Apps]]'
Additional '[]' are there because column header contains spaces!

Well, duh, that did it. Super obvious. Bad fingers....
Thanks.