Hello,
Have a look at the attached workbook. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nikhil Shah Envoyé : lundi 25 juillet 2011 20:58 À : excel-macros@googlegroups.com Cc : Maries waran Objet : $$Excel-Macros$$ Date Formula 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
Dates.xls
Description: MS-Excel spreadsheet