Is there a way to add subtract hours from a date? (GMT To EST)

JPSmartSheet ✭✭
edited 02/07/23 in Formulas and Functions

We receive timestamps for all our data in GMT time which is 5 hours ahead of EST. I am doing a vlookup from another table to pull in the dates in the 'date received' column. Is there a formula I can use to subtract 5 hours from the time pulled in to display in EST?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!