View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Days of a given month

Can anybody help me?
I need to get the number of days on a given month-year. (ie Jan-07 = 31
days, etc)

Is there an easy way to get it?


=DAY(DATE(YearNumber,MonthNumber+1,0))

Put the year number in the first argument, the month number PLUS one in the
second argument and zero in the third argument.

Rick