#1
|
|||
|
|||
Sytax error
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. |
#2
|
||||
|
||||
Parens look good but shouldn't brackets also be paired? A bracket in front of each @ looks odd to me.
|
#3
|
|||
|
|||
Must be e.g. '[@[Final Due Date for New Apps]]'
Additional '[]' are there because column header contains spaces! |
#4
|
|||
|
|||
Well, duh, that did it. Super obvious. Bad fingers....
Thanks. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
error handler: inserting building blocks when multiple cells in a table are selected creates error | LSLSLS | Word VBA | 2 | 01-07-2022 05:46 AM |
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error | PLSBRYDOBOY | Excel Programming | 0 | 08-30-2019 12:17 PM |
Automation error Unknown error" message once they open the Excel file | hlina | Excel | 1 | 10-08-2013 09:14 PM |
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!! | bennypryde | Office | 1 | 01-05-2012 03:33 PM |
Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |