dd/mm/yyyy from dd/mm/yyyy hh:mm:ss

[santhoshbes]

Hi All,

I would like to ask you a helpin excel formula.

Issue:

I would like to extract the date from one cell (i.e.) from dd/mm/yyyy hh:mm:ss format to dd/mm/yyyy.

I need to get this requirement with the help of formula.

Any one can helpme out.

Regards,
Santhosh

 

[Jonmo1]

Is the cell actually a Date/Time value?

=INT(A1) will remove the time from the cell.