Date Sum
 

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

Date Sum
 

Hi Rao,

Try:

=DATE(YEAR(B10),MONTH(B10)+1,0)


---
Regards,
Norman



"Rao Ratan Singh" wrote in message
...
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

Date Sum
 

Not sure what you're doing with the summing of dates, but one way to
get the last day of the month:

=DATE(YEAR(B10),MONTH(B10)+2,0)

In XL's reckoning, the zeroth day of the month is the last day of the
previous month.


In article ,
Rao Ratan Singh wrote:

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