Thread: # of days in that month for a selected date
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default # of days in that month for a selected date
Maybe a bit shorter

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

Format as general

Mike

"Narnimar" wrote:

What is the formula to return the # of days in that month for a randomly
selected date? Thanks for the help.
Reply With QuoteReply With Quote