View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Month days over a time period

Hi Peter,

Am Fri, 20 Sep 2013 08:47:49 +0100 schrieb Petertc:

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


please look he
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "DaysByMonth"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2