Dear All Members
Here I am posting my Question :
( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/yyyy
( 2 ). End Date : 05/05/2016 : Format will be dd/mm/yyyy
Now I want Answer in the Following manner :
( 1 ) . 31/08/2012...
( 2 ). 30/09/2012
( 3 ). 31/10/2012
( 4 ). 30/11/2012
Up to
05/05/2016 --- > End Date
This means......
I want the last date of each month from start Month to end Month and for
this the days should be calculated...accordingly
The Months which have 31 days should be counted 31 and months which have 30
days should be counted 30,if start month is incomplete the days should be
calculated accordingly , For End Month the days should be counted up to the
mentioned date.
For Ex. : My Starting Dt.25/08 but August has 31 days So, I will count
Difference Of 6 Days ( 31/08 - 25/08 )
My Ending Dt Will be 05/05/2016..So I will count only 5 days.
I want Formula Only .... I Do Not Want VBA Code...And I am using Office
Professional Edition 2003 Version...
Thanks
Nikhil Shah
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
