#of days remaining to the EOM
Make sure you have the Analysis toolpak installed (tools-add-ins and check
analysis toolpak)
The formula you want is
=EOMONTH(A1,0)-A1+1
"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.
|