J

#### JBrewster

past until, say May 1, 2013. In Column 1 I have 5/1/2013 for about 3

rows, and in Column 2 have dates beginning with 6/1/2010 (B2) and movin

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 th

formula for each row down. The first answer for C1 is 1065, and th

numbers change correctly as we go down the rows. However, A31 read

5/1/2013, B31 reads 7/12/2012, but C31 gives 10/19/1900, not 284 as i

should. In "Show Formula", I can see the numbers and subtract them t

get 284, but Excel will not allow me to put the numbers in. What is th

problem here? There are most likely other ways to get this done, bu

this is how I tried. OK through 30 rows, but 31 is out of whack. An

suggestions?

Thanks for your help