Finding count of all Sundays in the Given Date Range

[#1]

Hi All,

     I want to Find Count of all Sundays in the Given Data Range i.e From And To Date.

Eg.

     From Date        To Date

     1-Sep-2011     20-Sep-2011

Nos Of Sundays = 3

How Can I achieve this ?

[gandalfgray]

Hi Nandkishor

Try this  (replace 'sun' to what you use):

=sum({<Date={">=$(FromDate) <=$(ToDate)"}>} if(Weekday(Date)='sun', 1, 0))

hth/gg

[its_anandrjs]

Hi,

If it is single date column try this out for date column

=sum( if ( Weekday ( YourDateField ) = 'Sun', 1, 0 ) )

Regards,

Anand