ExcelBanter - month count

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - month count (https://www.excelbanter.com/charts-charting-excel/251418-month-count.html)

David

month count

How to set a formula to count the number of month between two dates?
example:
Jan 5,2009 to Feb 4, 2009 = 1 month
Feb 5, 2009 to Apr 6, 2009 = 3 month (round up)

David Biddulph[_2_]

month count

=DATEDIF(A2,B2+1,"m")+(DATEDIF(A2,B2+1,"md")0)
--
David Biddulph

"David" wrote in message
...
How to set a formula to count the number of month between two dates?
example:
Jan 5,2009 to Feb 4, 2009 = 1 month
Feb 5, 2009 to Apr 6, 2009 = 3 month (round up)

All times are GMT +1. The time now is 08:36 PM.