I can't get that to work yet Niek, but here is another one

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(YEAR(A1),1,1)&":"&DATE( YEAR(A1)+1,1
,0))))=1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Niek Otten" wrote in message
...
I used a formula from Chip Person's site,
http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear

With the year in A1:


=IF(YEAR(DATE(A1,1,1+((53-(1=WEEKDAY(DATE(A1,1,1))))*7)+(1-WEEKDAY(DATE(A1,
1,1)))))=A1,53,52)

This formula works for leap years as well.

--
Kind regards,

Niek Otten

"lsmft" wrote in
message
...
|
| I've noticed that there are 53 Sundays in this year 2006.
| My question:
| Is there a way for Excel to determine how many Sundays or any other day
| of the week that there is in a year?
| Also:
| Can Excel tell how often there will be 53 Sundays in a year?
|
|
| --
| lsmft
| ------------------------------------------------------------------------
| lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
| View this thread:
http://www.excelforum.com/showthread...hreadid=536328
|