Hi All,

I am trying to convert a list of EPOCH dates/times to readable local time (EST). Currently I am using the formula =((A1-14400)/86400)+25569 and it works until it hits the DST time.
Is there a formula that would account for the local time (EST) as well as account for DST without having to manually change the formula to match the DST.

Attached is a sample worksheet.

Conversion Data.xlsx

Thanks