ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtracting months from each other (https://www.excelbanter.com/excel-discussion-misc-queries/221389-subtracting-months-each-other.html)

zivro

Subtracting months from each other
 
I would like to know how I can subtract 2 dates from each other and as a
result get the difference in number of months.

Mike H

Subtracting months from each other
 
Hi,

With the earlier date in a1

=DATEDIF(A1,B1,"m")

Datedif isn't documented in excel, for help look here


http://www.cpearson.com/excel/datedif.aspx

Mike


"zivro" wrote:

I would like to know how I can subtract 2 dates from each other and as a
result get the difference in number of months.



All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com