View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSHAWARDHAN. S .SHASTRI[_2_] HARSHAWARDHAN. S .SHASTRI[_2_] is offline
external usenet poster
 
Posts: 69
Default How many months between two date range

Try this

=INT((A2-A1)/30)

Where A1 and A2 are end and start date.
--
HARSHAWARDHAN.S.SHASTRI

Pl do not forget to press "YES" button if post found useful.


"Talladega" wrote:

Hi,

I need a formula that can count how many months between two date range.

11/1/08 6/30/09 = 8
6/5/07 8/25/09 = 27
4/3/08 7/7/09 = 15

Thanks,