Thanks:  0
Likes:  0

# Thread: Count number of months

1. 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

2. 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,

3. On 2002-03-07 19:13, Barrie Davidson wrote:
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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•