Date Function

[jedilefty]

Hello everyone,

Can somebody help me out? I have a column of cells (column D) with a Date Time Stamp in the following format:

6/1/24 6:39

The time is in 24hr formatting. How can I keep this data but in another column (column L) have just the date in M/D/Y format?

 

[Joe4]

Are your entries in column D valid date entries, or dates entered as text?

If valid date entries, you could just use a formula like this:

=INT(D2)

for a value in cell D2 and format the cells as M/D/Y.

If it is entered as text, you can use this formula instead:

=DATEVALUE(TEXTBEFORE(D2," ",1))

 

[Scott Huish]

If you entered it as text, you could use this: =INT(--D2)