Thanks Ron & Stefi.

My MS office returns that the EMONTH function cannot be found. My MS office
is Office XP. Does the function not inclduding in this version.

The Date(year, month, day) formula is found worked. Pls be kind to explain
that :
- why the month value should add 1, i.e. B1+1
- does the value in B1 must be alphabet

Thanks a lot,


"Stefi" wrote:

Having year in A1, month No in B1:
=DAY(DATE(A1,B1+1,0))

Regards,
Stefi

€žyclhk€� ezt Ã*rta:

I prepare a report containing the daily average for every month in the year.
How can I set the formula (prefer not VBA) which can automatically identify
number of days for every month, i.e. in August, get the average of dividing
by 31; in September, get the average by dividing of 30 and so on ?