Issue
How to Remove Time from Date field in Microsoft Excel ?
If your DATE field of an excel file contains TIME also . In some situations you need to remove those time from the DATE field.
Soulution
If you want just show the field without time you can just right click and select format cell and format the field to another "date format"(Fig 02). This will remove the TIME.
(Fig 02)
But actually it will not remove the time from the field. In the formula section the TIME will still there. So in some cases you need to remove the time from the formula also, follow the below steps.
1. Insert 2 Column next to the DATE field (in this eg. date field is Column A).
2. Format 2 New column (B and C) to appropriate DATE format.
3. Add Following formula to column B and drag to end. formula =INT(A1)
4. Copy all content from Column B
5. Paste to Column C (Use paste special - paste values option)
6. Now Delete column A and B.
Now you can see there no time in your excel file.
