Assuming Jan 15 is in Cell A1 this formula should do it...

=DATE(YEAR(A1), MONTH(A1)+1, 0)-A1
--
HTH...

Jim Thomlinson


"Narnimar" wrote:

I need a formula to return no of days to that month for a given date in the
cell. If I enter 15-Jan 2009 in cell A1 the formula should return the no of
days remaining in that month in A2.
Appriiate anyone help me in this.