Excel Worksheet Tips: Extract Date or Time from Date/Time
Do you have a cell that contains both a date and time value but only need one or the other?
To extract the date
Assuming the date time value is in cell A1, you can use the following formula:
=DATEVALUE(MONTH(A1) & “/” & DAY(A1) & “/” & YEAR(A1))
To extract the time
=MOD(A1,1)
Come check out the directory for the rest of my excel tips!
Submeg
IT
SUBMEG 