| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days in a specific month between various start and end d
I am looking for a formula that will return the number of days of a
particular month between start and end dates. For example, if the start and end dates are as follows: 2/23/09 5/6/09 3/12/09 3/28/09 3/2/09 4/16/09 How many days is there in April for each of the three start and end dates? For the first record, there should be 30 days, for the second, 16 days, and for the third, 55 days, but what is the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I calculate number of days based on start and end dates? | Excel Worksheet Functions | |||
| Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
| Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
| Counting number of days up to an empty cell then start over again | Excel Discussion (Misc queries) | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Threaded Mode
