hi i have query im not able to take time part from date and as below
29/04/2010 10:30 AM, i need only date, i have array as followos
A1 b1 c1
29/04/2010 10:30 am 29/04/2010 3:30PM =if(a1=b1,"SDD","no SDD")
due to time slot im not able execute, if executes its turnout to be wrong out put pl help me