Re: Days from date calcuatlor

Re: Days from date calcuatlor   (10/02/2015, 9:06 PM)

Excel actually stores dates as integers on the backend, so you might be able to just add a number to all your data.

June 1, 1981 = 29738 in Excel

So if your June 1, 1981 = 4901, then you should be able to just add 29738 - 4901 = 24837 to every date to get it into Excel.

Note that different versions of Excel may use a different starting point if you're on Mac or PC, so test it first and adjust the offset if necessary.

Once you get all the integers in a column in Excel, you should be able to reformat the cells as dates to see the full date displayed.