We have had several customer discussions recently regarding date formulas, as dates are an important aspect of financial data.
All of the date/times used throughout the Add-in are in UTC format.
UTC (Coordinated Universal Time) is the main global time standard and establishes a single timezone across the planet.
The question is, how does a UTC time translate to my local (timezone) time?
You may search on the web and find a simple solution that adds or subtracts a number of hours to the date, however these solutions do not account for adjustments due to daylight savings time.
We have therefore started adding some general date formulas to our software, the first of which is: EPF.Dates.UTCToLocal
This simple Excel formula is useful for converting any UTC date/time to the date/time in the timezone of your PC/Excel. It handles all timezones as well as daylight savings.
We’ve created a quick video to show this formula in action:
We are looking at adding more date functionality around timezones. Do let us know if there is some date functionality that you think is missing from Excel and we can look into adding it.
The Excel Price Feed Blog 