Calculate the number of Months between dates

**Johndrew** · 09-03-2010, 01:51 AM

I need to calculate the depreciation expensed for an assets sold.

I have the purchase date 07/14/07 and sold it on 06/04/10

I need the months between the two dates

**zbor** · 09-03-2010, 02:08 AM

Maybe this: =12*(YEAR(B1)-YEAR(A1))+MONTH(B1)-MONTH(A1)

**contaminated** · 09-03-2010, 02:18 AM

Another way is

=DATEDIF(PurchaseDate;SoldDate;"m")

or

=INT((E11-D11)/30)

Read more about DATEDIF function

Calculate the number of Months between dates

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Calculate the number of Months between dates

Re: Calculate the number of Months between dates

Re: Calculate the number of Months between dates

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions