for month end date ... =DATE(YEAR(A1),1+MONTH(A1),1)-1
On Tue, Jul 26, 2011 at 12:28 AM, Nikhil Shah <nikhil201...@gmail.com>wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
