Sequential dating in excel

What this means is Excels internal date system believes there was a , when they wasn't!

The surprising part is, Microsoft did this intentionally!

The most reliable way to automatically number rows in Excel is to use the function.

sequential dating in excel-81

Sequential dating in excel

To see the true value of a date and/or time simply format the cell as "General".

For example the date and time 3/July/2002 PM has a true value of 37440.625 with the number after the decimal representing the time and the 37440 being the serial value for 3/July/2002 For more detail see: "How Microsoft Excel stores dates and times" in the help. Excel incorrectly assumes that the year 1900 was a leap year.

Click "Sort." Nick Peers has been writing technology-related articles since 2003.

His articles have appeared in dozens of technical publications, including MSN UK, CNET, BBC Who Do You Think You Are, Life Hacker UK and Tech Radar.

He holds a Masters in information technology degree from the University of East London.

Last modified 31-May-2016 07:28