Thanks Celcilia, There are other workarounds available, which we can use instead of EOMONTH. and now I got your main requirement as well.
If you wish, you can include a code which will autmatically enable / installs the ATP, when the users open the workbook. For the later part, I was also looking for SUMPRODUCT, but let me consider other options as well and would get back to you on this front. 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: > > 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!<http://www.vivelive.com/historiasdehotmail/> > > -- > > ---------------------------------------------------------------------------------- > 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 > > > > > ------------------------------ > ¡Nuevo MSN Deportes! Sigue los partidos en directo y encuentra la última > información de tus equipos favoritos. <http://deportes.es.msn.com/> > -- ---------------------------------------------------------------------------------- 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
