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

03-13-2022, 04:16 PM

rollis13

Windows 10 display a change in column cells counting the number of months

Office 2016

Competent Performer

Join Date: Jan 2021

Location: Cordenons

Posts: 143

Maybe for cell D6 then pull down:

=IFERROR(DATEDIF(A6,B6,"y")*12+DATEDIF(A6,B6,"ym") ,"")

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 06:58 AM.