Finding the number of Days in the month?

G

Guest

If there a way to return the number of days in the month? within a formula?
I want to calculate the % run time and I have a col with the runtime for
March 2007. I have the Date March-07 in A2 and the Runtime for that month in
B2. I would like the % runtime in C2.
 
B

Bob Umlas

=day(date(year(a2),month(a2)+1,0))
will give #days in the month in A2.
Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running YTD Percentages 1
Day of month to Date in month 2
Moving range? 6
dates of month automation 3
Dynamic Reference Cell in Offset Formula 3
Rolling Year-to-Date Percentages 3
Automatically enter a percent for each month of the year. 4
Days in a month 7

Top