View Single Post
  #1   Report Post  
Petertc Petertc is offline
Junior Member
 
Posts: 3
Default 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