Hi @richlodge5 Here is the BAAAM Date formula:
=((A2/1000)/86400)+(DATEVALUE("1-1-1970")-DATEVALUE("1-1-1900"))Make
sure you replace the 'A2' to reference the the date cell you are trying
to change. Also make sure that the raw (reference) date column (in this
example 'A2') is formatted as general. The new date column will need to
be formatted as 'Custom' and then you should make it: m:dd:yyyy AM/PM.
It can get a bit wonky sometimes so if anyone else has a better way
please share. Thanks,Manny