Finding the number of Days in the month?

W

Will

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

number of months and days between two dates without approximation 3
Date Calculation - Astro Calculation 0
Running YTD Percentages 1
Moving range? 7
Day of month to Date in month 2
Month days over a time period 5
Convert Text to Date Month and Year 1
dates of month automation 3

Top