Daily Average
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 ?
|