Sundays in a given period 1

[cairo207]

How do I count the number of sundays in a given period?
Also if the start date is a subday, the formula should count that sunday, and, if the end date is a sunday, the formula should not count that sunday.

 

[robcarr]

this will check for sundays between dates

Function GetSundays(Date1 As Date, date2 As Date)
Dim x As Date
Dim y As Integer
y = 0

For x = Date1 To date2
If Weekday(x) = 1 Then y = y + 1
Next x
GetSundays = y

End Function

you would use

getsundays(datelogged,dateclosed)

Hope this is of use, Rob.