I need to determine the # of days from several dates for about 2 years past until, say May 1, 2013. In Column 1 I have 5/1/2013 for about 31 rows, and in Column 2 have dates beginning with 6/1/2010 (B2) and moving down about a month at a time so the last row is B31, with 7/12/2012. Column 3 rows use the formula =(A1-B1), changing the row listed in the formula for each row down. The first answer for C1 is 1065, and the numbers change correctly as we go down the rows. However, A31 reads 5/1/2013, B31 reads 7/12/2012, but C31 gives 10/19/1900, not 284 as it should. In "Show Formula", I can see the numbers and subtract them to get 284, but Excel will not allow me to put the numbers in. What is the problem here? There are most likely other ways to get this done, but this is how I tried. OK through 30 rows, but 31 is out of whack. Any suggestions?
Thanks for your help.