Re: count days

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 07/10/04 

Date: Sat, 10 Jul 2004 15:52:23 +0200

Hi
now depending on your settings try
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2 & ":" & A1)))={4.7}))

(this works if the semicolon is used as delimiert -> the dot is used
for these arrays). What language version of Excel are you using? 

--
Regards
Frank Kabel
Frankfurt, Germany
giorgio wrote:
> Ctrl C Ctrl V
> Which are yor setting: office and regional and language options
> i think the problem is {4,7}
>
> regards
> thanks
>
> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
> news:eCdTotnZEHA.1448@TK2MSFTNGP12.phx.gbl...
>> Hi
>> works for me. Have you entered the date values in cell A1 and A2?
And
>> what exact formulas have you entered?
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>>
>> giorgio wrote:
>>> 3. Result = 0 ?
>>>
>>>
>>>
>>> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
>>> news:#$pGv#mZEHA.2340@TK2MSFTNGP09.phx.gbl...
>>>> Hi
>>>> try the following:
>>>> 1. In A1 enter this date (e.g. 10/07/04)
>>>> 2. In A2 enter a formula to calculate the first day of this month:
>>>> =DATE(YEAR(A1),MONTH(A1),1)
>>>> 3. Enter the following formula to calculate the number of
Saturdays
>>>> and Wednesdays:
>>>> =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2 & ":" & A1)))={4,7}))
>>>>
>>>> --
>>>> Regards
>>>> Frank Kabel
>>>> Frankfurt, Germany
>>>>
>>>>
>>>> giorgio wrote:
>>>>> How I can construct a "count" that gives back to the sum, month
by
>>>>> month, of all the wednesdays and saturdays until the day of
>>>>> calender ? ex if day is 10/07/04 = result 3, if 29/07/04 = 8, if
>>>>> 10/08/04 = 2, if 23/09/04 = 7, if 13/10/04 = 4, ...etc naturally
>>>>> control the result the same day of the calendar ex
today(10/07/04)
>>>>> =3.
>>>>>
>>>>> Thanks