$$Excel-Macros$$ Re: total Fridays in a range

2013-11-07 Thread itware2008
Please take a look at the enclosed file. You are able to select from the drop-down box the weekday you are looking for, below you find the number of occurrences for the weekday you had chosen. Cheers. Terça-feira, 1 de Outubro de 2013 15:18:15 UTC+1, asd...@gmail.com escreveu: vba returns

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-03 Thread ashish koul
do you want to sum all the values of Fridays of each month On Wed, Oct 2, 2013 at 6:09 PM, asd...@gmail.com wrote: On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value should be 5. Plse refer to

$$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value should be 5. run your vba, the result as shown on Snap2.png is not I wanted. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Wednesday, October 2, 2013 4:07:13 PM UTC+8, ashish wrote: can u share hw wuld u like to see thn if SUM((WEEKDAY(A2:A6)=6)) = 5 then .. On Wed, Oct 2, 2013 at 1:01 PM, asd...@gmail.com javascript: wrote: On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread koul . ashish
Can u explain it in detail Sent on my BlackBerry® from Vodafone -Original Message- From: asd...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 Oct 2013 01:22:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re

$$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value should be 5. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

$$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread asdhhc
On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value should be 5. Plse refer to the attached example. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s