#of days remaining to the EOM
 

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.

#of days remaining to the EOM
 

=date(year(A1),Month(A1)+1,1)-A1
re-formatted as General

"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.

#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.

#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.

#of days remaining to the EOM
 

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.

#of days remaining to the EOM
 

This formula give you 15 - through 31st inclusive so the answer is 17. If you
did not want to caount the 15th then you would go with mine and Peo's or my
solutions of

=date(year(A1),Month(A1)+1,0)-A1

Which gives you 16.
--
HTH...

Jim Thomlinson


"Bob Umlas" wrote:

=date(year(A1),Month(A1)+1,1)-A1
re-formatted as General

"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.