Forum Discussion
Extract Date
Dear Experts, Can you please help extract the Date from the cells as below :- Thanks & Regards Anupam Shrivastava
Or
=TRUNC(A2)
=QUOTIENT(A2,1)Or
=ROUNDDOWN(A2,0) =FLOOR.MATH(A2)In my limited testing (a few trials of 10,000 cells each), FLOOR.MATH was the fastest, with INT a close second; QUOTIENT was the slowest,.
