#of days remaining to the EOM
=DATE(YEAR(A1),MONTH(A1)+1,0)-A1
then you need to change the format to general since that formula will trick
Excel into a date format
--
Regards,
Peo Sjoblom
"Narnimar" wrote in message
...
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.
|