On further reflection, you can change the formula I gave you earlier to:
=DATE(1970,1,1)+B2/86400
This eliminates the need for the 1/1/1970 in cell B1 plus combined division.
pw
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Formula for converting a unix timestamp to a readable date?