Quote:
Originally Posted by MikeM3
Attempting to add a few cells together I entered the formula =SUM(B4:F4),
press enter and I get a date 18/03/1900, to try and fix it, I deleted all
and in 3 different columns I entered 100, 50, 50 then in the "G" I put the
above formula and got 19/07/1900.
|
Excel stores dates as the number of days since 31/12/1899.
In your example, 100 +50+50 = 200. 200 days from 31/12/1899 is 18 July 1900. Therefore the simple answer is that
your formula cell was formatted as a date. All you needed to do was change the number format as mentioned and you would have seen the correct result.
01-14-2016, 01:18 AM
Similar Threads
Formula to return a date
Windows 7 64bit 
Office 2010 32bit
Threaded Mode