I am getting the data from BI Query.
Everything is fine till the data.
A1 B1 C1 D1_
SALES DOC NO DATE TODAY DIFFERENCE
101 21/10/2010 08/02/2011 08/02/2011 - 21/10/2010
102 21/08/2010 08/02/2011 08/02/2011 - 21/08/2010
103 21/07/2010 08/02/2011 08/02/2011 - 21/07/2010
The A1 & B1 cells getting the data from BI Query, what i am trying to do is c1 cells i am calling todays date,
I am want to minus the date(B1) with Todays date(C1). Definelty it gives the number, but when i am trying to
call the D1 and A1 cells it throws the #value.
Experts Kindly help me in this regards, where i am going wrong, how to display the difference.
I have also changed the D1 cells format in number.
Edited by: sumanchuman on Feb 8, 2011 10:05 PM