|
|
#1
03-13-2022, 09:14 AM
|
|||
|
|||
display a change in column cells counting the number of months
Hi folks. I have a spreadsheet (see attached) where I have specific from and to dates in column A and B. I need a formula to show (in column D) the number of months between the month in column A and column B of the same row.. I suspect I need to use the month function here, but I can't figure out how to do it. Suggestions? Thanks
|
|
#3
03-13-2022, 04:24 PM
|
|||
|
|||
|
Maybe did you mean A6,B6 rather than A8,B8? Because this does seem to work. I have no idea why, I will need to analyze the formula. But thanks for your help, it solved my problem.
|
|
#5
03-14-2022, 12:22 AM
|
||||
|
||||
|
Why not simply ?
Code:
=IFERROR(DATEDIF(A6;B6,"m"),"")
__________________
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
|
|
|
|
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 |
Windows 8 
Office 2013
Linear Mode
