I'm using the above and want to do something simple. In cell A1 I typed in
the date 3/31/2006. Then starting is cell B2 and continuing in that row, I
want the end of the month to show up. So in B2 I want to see 4/30/2006 and in
C2 I want to see 5/31/2006 and so on. I put in this formula in B2
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) but it returns 5/1/2006 not 4/30/2006.
Why and what do I need to do to get it to work the way I've described?