# converting days to months

1. ## converting days to months

I was able to convert start date and and end date to the number of days
inbetween the two dates. Does anyone know how to then convert the number of
days into months?

2. ## Re: converting days to months

Try:
=MONTH(A2) - MONTH(A1)

Or:
=MONTH(A2) - MONTH(A1) + IF(DAY(A2)>DAY(A1), 1, 0)

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Julie" <Julie@discussions.microsoft.com> wrote in message
news:EB621787-DD1B-450A-9FB8-429C5A9813FB@microsoft.com...
>I was able to convert start date and and end date to the number of days
> inbetween the two dates. Does anyone know how to then convert the number
> of
> days into months?

3. ## Re: converting days to months

One way:

=DATEDIF(<start date>,<end date>,"m")

See

http://cpearson.com/excel/datedif.htm

In article <EB621787-DD1B-450A-9FB8-429C5A9813FB@microsoft.com>,
"Julie" <Julie@discussions.microsoft.com> wrote:

> I was able to convert start date and and end date to the number of days
> inbetween the two dates. Does anyone know how to then convert the number of
> days into months?

4. ## Re: converting days to months

Hi

Use Datedif to find number of months between two dates:
=DATEDIF(A1,B1,"m")
And you know of course that 28 days may or may not be a whole month, so this
is not a very precise way to measure time.

HTH. Best wishes Harald

"Julie" <Julie@discussions.microsoft.com> skrev i melding
news:EB621787-DD1B-450A-9FB8-429C5A9813FB@microsoft.com...
> I was able to convert start date and and end date to the number of days
> inbetween the two dates. Does anyone know how to then convert the number

of
> days into months?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1