![]() |
|
#4
|
|||
|
|||
|
I'll look at your table tomorrow then, as I don't have Office in my home computer.
But having your formula return #VALUE! error on the rows that must actually have dates may be because in column T are not dates at all, but datestrings! |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I want my formula to result in zero if referenced cell = 0, otherwise calculate | Daronovitz | Excel | 2 | 12-21-2022 11:44 AM |
| Filling a formula down a column where only one cell value referenced changes? | sakurasanta86 | Excel | 1 | 08-27-2018 03:23 AM |
Filling a formula down a column where only one cell value referenced changes?
|
takamaz | Excel | 2 | 03-11-2018 08:56 AM |
| Random cell return using vlookup formula | mattbeaves | Excel Programming | 3 | 05-22-2017 04:38 AM |
Formula to return next non-blank cell in a range
|
Anyroad | Excel | 4 | 09-15-2015 04:13 PM |