Thread: Days in a month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Days in a month

On Fri, 9 Oct 2009 07:49:01 -0700, helpforwork
wrote:

Is there a formula that can populate how many days there are in a month? i.e.
31 days in January, 28 days in February, and so on


With some date in A1:

=DAY(A1-DAY(A1)+32-DAY(A1-DAY(A1)+32))

Format result as General, or Number
--ron