Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default #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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default #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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default #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.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,081
Default #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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default #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.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default #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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate vacation days remaining from date of employment sanfrangirl Excel Worksheet Functions 1 June 25th 08 08:59 PM
Please Help With Days Elapsed And Days Remaining Calculation Scoooter Excel Worksheet Functions 2 June 14th 06 05:10 PM
Getting remaining entries harvindersingh1 Excel Discussion (Misc queries) 1 April 21st 06 03:32 PM
Points remaining formula jbsand1001 Excel Worksheet Functions 1 January 6th 05 12:11 AM
Calculate Remaining Balance cindi Excel Worksheet Functions 2 December 8th 04 05:41 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"