|
|
|
|
#1
11-13-2018, 03:38 PM
|
||||
|
||||
I pasted the formula in a cell and then I preses Ctrl+Shift+Enter and it gave me the message "the formula you typed contains an error"[/quote]
There is an error because "today" is Nov 14 and you do not have nov 14 in your data. Insert a cell where you type your reference date, like Xor's table. Replace TODAY() with the cell address of your reference date. Learn to name your table and range, it is very flexible when copying formulas down rows or across columns. I guess IF ISNA is not applicable with INDEX MATCH function so remove / edit the formula. See the formula in D3 and E3, compare it with D2 and E2. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help with Formula to extracting text from text string
|
Haha88 | Excel | 9 | 02-05-2018 01:04 AM |
| Formula to Extract text from a text string | Haha88 | Excel | 2 | 11-14-2017 01:32 AM |
| If text in column then formula in other | Grubermen | Excel | 1 | 09-06-2017 06:35 AM |
|
Editing the text a formula gets me
|
Jiing Chiang | Excel | 7 | 02-08-2016 10:01 PM |
| extract text with formula | s7y | Excel | 7 | 06-05-2013 06:18 AM |
Windows 7 32bit 
Office 2007
Hybrid Mode