Thread: Daily Average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yclhk yclhk is offline
external usenet poster
 
Posts: 48
Default Daily Average

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 ?