SyntaxFix
Write A Post
Hire A Developer
Questions
Have you tried the =DateValue() function?
=DateValue()
To include time value, just add the functions together:
=DateValue(A1)+TimeValue(A1)