Thread: Counting Dates
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Counting Dates

On Wed, 28 Dec 2005 18:11:02 -0800, "billy"
wrote:

Hi,

I have two dates: 1/1/01 & 5/25/04
How can i write a formula that will show the number of months from 1/1/01
thru 5/25/04? This should show 53. I don't need days but months.

Thanks,


How can there be 53 months from 1 January 2001 to 25 May 2004 given that there
are only twelve months in a year???


--ron