Tricky excel exercise

OSB · 7 Nov 2007 at 20:51

Hi guys, i'm having difficulty in trying to make a spreadsheet in excel. Basically it needs to show that the 13ths in the months fall on fridays more often than any other day. So it needs to be able to count up the number of time each day lands on the 13th in a 400 year period (which is the period of the gregorian calender). Now i can use excel, but i can sem to think how to get it to do this.

Any ideas???

OSB

OSB · 8 Nov 2007 at 08:31

Yeah over 100 years it may be even but the gregorian calendar has a period of 400 years so that when you take a 400 year period, with all its gap years, into account it does actually occur more often on a friday. but only slightly. I have managed to do this now but it was rather long winded. Thanks for your help guys.

OSB