Count number of months

JRyan · Mar 7th, 2002, 08:09 PM

I want to put a past date, say
6/99 in cell A1 and a more recent date say
4/02 in cell B1
I want the number of months to be counted and placed in C1

Thanks
John

Barrie Davidson · Mar 7th, 2002, 08:13 PM

Quote:

On 2002-03-07 19:09, JRyan wrote:
I want to put a past date, say
6/99 in cell A1 and a more recent date say
4/02 in cell B1
I want the number of months to be counted and placed in C1

Thanks
John

Try
=(YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1)

Regards,

JRyan · Mar 7th, 2002, 08:17 PM

Quote:

On 2002-03-07 19:13, Barrie Davidson wrote:

Quote:

On 2002-03-07 19:09, JRyan wrote:
I want to put a past date, say
6/99 in cell A1 and a more recent date say
4/02 in cell B1
I want the number of months to be counted and placed in C1

Thanks
John

Try
=(YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1)

Regards,

HI Barrie
I don't understand it but hey it works great and I thank you very much for your help
John

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 08:09 PM	#1
JRyan New Member Join Date: Mar 2002 Posts: 6	I want to put a past date, say 6/99 in cell A1 and a more recent date say 4/02 in cell B1 I want the number of months to be counted and placed in C1 Thanks John