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?
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?
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" <[email protected]> wrote in message
news:[email protected]...
>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?
One way:
=DATEDIF(<start date>,<end date>,"m")
See
http://cpearson.com/excel/datedif.htm
In article <[email protected]>,
"Julie" <[email protected]> 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?
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" <[email protected]> skrev i melding
news:[email protected]...
> 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)
Bookmarks