Looking to convert a date from this format 4/12/2017 15:44:26 to this format 42826.315277778. I've tried to use a couple different functions such as num(), but no luck thus far. Any guidance would be appreciated!
=Num(Timestamp#( '4/12/2017 15:44:26','M/D/YYYY hh:mm:ss'))
but you need to check the format of your input value, is it a numeric or text format?
Why don’t my dates work?
Retrieving data ...