display a change in column cells counting the number of months

		Microsoft Office Forums > Microsoft Excel > Excel
display a change in column cells counting the number of months

FAQ

Thread Tools

Display Modes

03-14-2022, 12:22 AM

Pecoflyer

Windows 7 64bit display a change in column cells counting the number of months

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Why not simply ?

Code:

=IFERROR(DATEDIF(A6;B6,"m"),"")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting that highlights cells when there was a change in another column	Marcia	Excel	4	04-28-2019 07:34 AM
Pivot table- % growth and difference between two items in same column by months	sarana	Excel	2	01-28-2019 06:42 AM
Word 2016: How do I change a REF field code to display a reference to a Roman number as Arabic	Peggy Sue	Word	1	08-15-2017 09:50 PM
showing months in another duration column	ketanco	Project	8	01-20-2015 07:27 AM
Counting Number of Months from a static date	bremen22	Excel	4	11-25-2013 11:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 AM.