vlookup a date from pivot table, can not add days to it and show date

[determinedtoexceed]

Hey Pros,

I use vlookup on a DATE from array "=VLOOKUP($CB5&COLUMNS($CC$4:CC4),$BY:$BZ,2,0)",

locate in (CC5), and I want another cell (CI5) to be (CC5 10 days later ), but function =CC5+10 will show #value ! error ,

please teach me on how to do this correctly.

Thank you

 

[Gerald Higgins]

What value is returned by CC5 ?
Is it actually a date, or is it a text string that looks like a date ?
To check this, try
=isnumber(CC5)
If you get TRUE, then the value in CC5 is a number, which can be represented as a date (usually).
If you get FALSE, then CC5 may be a text string, which can possibly be converted to an Excel date, but you'll need to give us more details.

 

[determinedtoexceed]

What value is returned by CC5 ?
Is it actually a date, or is it a text string that looks like a date ?
To check this, try
=isnumber(CC5)
If you get TRUE, then the value in CC5 is a number, which can be represented as a date (usually).
If you get FALSE, then CC5 may be a text string, which can possibly be converted to an Excel date, but you'll need to give us more details.

Dear Gerald,

=isnumber(CC5) return false, the lookup for column "$BY(=BS5&COUNTIF($BS$5:BS5,BS5)" is from a pivot table.

Please advice on next step, thank you very much~

 

[determinedtoexceed]

Hi Gerald,

I found the fix to this issue, thanks for the help