| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the number of Days in the month?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the number of Days in the month?
=day(date(year(a2),month(a2)+1,0))
will give #days in the month in A2. Bob Umlas Excel MVP "Will" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of work days/month | Excel Worksheet Functions | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| How can I add up lookups? Finding days in a week of a month | Excel Discussion (Misc queries) | |||
| Finding number of particular days in a period | Excel Worksheet Functions | |||
| number of days in a month | Excel Worksheet Functions | |||
Linear Mode
