| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Breaking down days between dates
Given two dates (e.g. November 7, 2004 and January 16, 2005) I am trying to
identify how many days are in November, December, and January. The dates represent meter readings and I am trying to breakdown how much of the overall consumption can be assigned to each individual month. In the example above 7 days in November, 31 in December, and 16 in January. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duration days | Excel Discussion (Misc queries) | |||
| Repete Dates at a value of 28 days, 56 & 84 | Excel Worksheet Functions | |||
| need help with formula | Excel Discussion (Misc queries) | |||
| convert dates to number of days | Excel Worksheet Functions | |||
| Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
