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,.