Hi Tia,
you can try "=SUMPRODUCT(--(WEEKDAY(range)=1))" though it will calculate
only the sundays you can give your range of cells which contains the dates of
the year 1 represents the first day (sunday) of week.

" wrote:

Hey Guys, i am trying to find a formula that calculates the number of
annual leave allowed pr year and i cant find find it