Number of days of each month

[johnfullerroot]

Hi

I have a excel sheet that records stats for each working day, mon through fri for week1, 2, 3, 4, and 5 of the month. The problem is that each month has different numbers of days in them for example febuary has 28 days (4 week) while others have 31. My worksheet has a cell where the user enters the date of the first monday of the month e.g. 04/04/2005 and then enters the date above each day for the rest of the month but goes all the way through to week five regardless of whether thats a new month. What I need is a way of determining how many days there are in a given month so that my worksheet wont use week five if there is no week 5 for that month. so for example if I type the date in one cell another cell with give me a value of the number of days in that month. Is this possible. Can anyone help?

Thanks

[tonywig]

This forumla will show you the number of days in the month that is in cell A1.

=DAY(EOMONTH(A1,0))

Hope that helps.

[johnfullerroot]

Sounds like the perfect thing but it doesnt work. I enter for example 01/04/2005 in cell A1 and put the above formula in a cell and it returns #name?

[tonywig]

Ahhh. It appears (in Excel help if you need more details) that you need Analysis ToolPak Add-In available to use EOMONTH.

Check out help for EOMONTH and it'll talk you through it.

Apologies for not checking first.