Time part out of date format

Closed
sandy - Apr 30, 2010 at 02:04 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 30, 2010 at 06:36 AM


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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 30, 2010 at 06:36 AM
try this


=IF(TEXT(A1,"dd/mm/yyyy")=TEXT(B1,"dd/mm/yyyy"),"SDD","no SDD")
0