Re: $$Excel-Macros$$ instead of formula need macros

No helper =SUMPRODUCT((WEEKDAY($G$2:$G$17)>1)*(WEEKDAY($G$2:$G$17)<7)*($H$2:$H$17=B3)) Don Guillett SalesAid Software dguille...@gmail.com From: Lokesh Loki Sent: Friday, February 24, 2012 9:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ instead of formula need

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please see attached sheet as per ur requirement. Thanks & regards, Noorain Ansari ** *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Fri, Feb 24, 2012 at 8:45 PM, Lokesh Loki wrote: >

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please see attached sheet with solution. >

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please use it without using Helping Column. =SUMPRODUCT(--($H$2:$H$51=B3)*(TEXT($G$2:$G$51,"ddd")<>"Sat")*(TEXT($G$2:$G$51,"ddd")<>"Sun")) On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please see attached sheet with solution. > > Hope it help to you. > >

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki wrote: > Hi Noorain, > > Please find the attached sample excel file for your reference. > > Regards > Lokesh.M > > > On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI > wrote:

Re: $$Excel-Macros$$ instead of formula need macros

Just i want to count the working days based on names in the listed file through macros. (except Saturday and Sunday) regards Lokesh.M On Fri, Feb 24, 2012 at 8:13 PM, dguillett1 wrote: > send a file with a complete explanation. > > Don Guillett > SalesAid Software > dguille...@gmail.com > >

Re: $$Excel-Macros$$ instead of formula need macros

send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.com From: lokesh Sent: Friday, February 24, 2012 7:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ instead of formula need macros Hi All, I am using this formula to extract the workin

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Can you share a sample sheet..What is your adject requirement. > > On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > >> Hi All,*

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > Hi All, > > ** ** > > I am using this formula to extract the working days in a month, but this > formula is very big and while pulling the report it takes too much t