Dilip, thanks a lot, but my problem is EOMONTH function. Isn't part of the Analisys Toolpack?? I can't use it, since this file will be distributed to more than 2000 people, and they might or might not have the addin installed. Is it possible to add the EOMONTH function as UDF, thus it can be available for everybody??
Also, on the table at the bottom (by resource), I would like to improve my formulas, since in the real file I will have more than 1000 lines. I was trying with sumproduct logic, but can't make it work (Div/0 error). Any ideas? Thanks a lot, Cecilia Date: Sat, 23 Jan 2010 20:13:22 +0530 Subject: Re: $$Excel-Macros$$ Function to return days by month From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: cecic...@hotmail.com Dear Cecilia, Solved workbook is attached herewith. I foresee that the solution can futher be customised, if you find this interesting and useful. Let me know in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/23/10, Cecilia Chiderski <cecic...@hotmail.com> wrote: I need help. I have a Start Date and End Date, formated as date. I need to calculate the days by month covered by this start/end. Example is attached. Also, based on the days by month, I need to calendarize assignment by resource (see attached file). I CAN NOT use in this model any of the Analysis Toolpack functions. I CAN use VBA UDF. Thanks, Cecilia Llévate gratis un Mazda 2 y una Xbox 360. ¡Participa con Hotmail! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ http://www.quemovileres.com/ ¡Descubre qué Móvil eres! Hay uno hecho para ti. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
