This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Great suggestion Michael. The same method is also useful if you ever have to convert MS Excel dates that are coming across in the serial format. For that one 'time started' on 1900-Jan-0 so that would be your beginning in the date add function
Since I've seen this create some confusion at times, I always like to point out that the Excel date sometimes needs "tweaks" to the formula (as in adjusting a day or two) because of the way Excel treats dates depending on the platform and because it assume 1900 was a leap year.