Thread: Find days in a Month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jman Jman is offline
external usenet poster
  
Posts: 110
Default Find days in a Month


"Jman" wrote:

I want to know how many days are in a month.
In A1 I have a date ex. 3/3/08.
In B1 i want to give me total days in that month.

Is there a formula for that.

nevermind i got it..

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

Reply With QuoteReply With Quote