Excel: what is the unit in date type series used in functions

Question

Hi there, dumb questions (but I did google around and searched SO):

I'm using the SLOPE Excel function on a date data type time series: 1 jan, 1 feb, 1 mar and so on... I can't figure out the x axis time unit assumed in the resulting calculation so the number is quite useless to me.

Any hints?

Cheers, Edoardo

Answer 1

Hello all,

here's the answer to my question: in dates, the day is the integer part starting from 01-01-1900 while the decimal part represent the time (which timezone? ah, I don't think it's accounted for ;) )

Details here: http://support.microsoft.com/kb/214094