Thank you for this site that i was able to solve my excel problem in getting how many mondays are there in a month. But after knowing it how I found out that i alsol need to get the exact date of all mondays in a month. Say for Jan 2011 there are 5 mondays then i need to know what dates are those. I'm expecting that excel will give me result of Jan 3, Jan 10, Jan 17, Jan 24 and Jan 31. Can you help me please?