Project Euler Problem 19
You are on the Home/Other Tutorials/Project Euler/Problem 19 page
Google
Web This Site

Project Euler - Problem 19

More about Project Euler.

Problem description

You are given the following information, but you may prefer to do some research for yourself.

1 Jan 1900 was a Monday.
Thirty days has September,
April, June and November.
All the rest have thirty-one,
Saving February alone,
Which has twenty-eight, rain or shine.
And on leap years, twenty-nine.
A leap year occurs on any year evenly divisible by 4, but not on a century unless it is divisible by 400.

How many Sundays fell on the first of the month during the twentieth century (1 Jan 1901 to 31 Dec 2000)?

Solution

There are 1,200 months in the century.

Enter in some cell the formula =SUMPRODUCT(--(WEEKDAY(DATE(1901,ROW(INDIRECT("1:1200")),1))=1))