I m using this function for Date sum =DATE (YEAR (B10), MONTH (B10) +1, 31).
This function calculates Days which we specify in this function. Is there any
way that days of particular month automatically detect last day of the month?

1/1/2006
1/2/2006
Its sum should be = 3/31/2006

Thanks and Regard

RRS