| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Month days over a time period
I have a problem where i need to calculate the number of days per month over a time period longer than 1 year.
Example if we have a start date of 1 January 2012 and an end date of 30 January 2013. I would like to get the following answers January 61 days February 28 days March 31 days April 30 days May 31 days June 30 days July 31 days August 31 days September 30 days October 31 days November 30 days December 31 days The reason for this is i have a average daily values that our different for each month and i need to multiply these number of days. Any help would be appreciated Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number of week days in a period of time | Excel Worksheet Functions | |||
| add number of days within a department for a given time period | Excel Worksheet Functions | |||
| Number of days in a running period | Excel Worksheet Functions | |||
| Finding number of particular days in a period | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Threaded Mode
