Find number of months in a specific year a date has been running?

[SkiliedSin]

Hello all,

I’m trying to find a function that’ll give me how many months a cell has been running for in a specific calendar year disregarding the start date.

For example, for different cells containing start dates 1/1/19 and 1/1/20, I would want to find how many months they were running in 2020. Considering I have columns 1/31/20, 2/28/20 etc through 12/31/20, I am looking for a function that’ll produce 1,2 through 12 for each of those start dates I mentioned earlier.

 

[SkiliedSin]

I have attached an image, highlighting the portion I am looking for.

 

[SkiliedSin]

Bump

 

[Fluff]

Not sure if I'm missing something, but how about

=MONTH(B1)

 

[SkiliedSin]

Not sure if I'm missing something, but how about

=MONTH(B1)

Unfortunately, if I changed the date to say 2/1/2020 in A3, I would be looking for a function that'll spit out "1" in C2 rather than "2"

 

[Joe4]

Unfortunately, if I changed the date to say 2/1/2020 in A3, I would be looking for a function that'll spit out "1" in C2 rather than "2"

Personally, I do not understand how exactly you want this to work. The logic is not clear to me.
Why would row 2 (cell C2) be looking at row 3 (cell A3)?

Perhaps it would be better if you post some more sample data, and walk us through a few different scenarios, explaining exactly how you arrive at your expected result for each of them.

 

[Fluff]

But you said to disregard the start date.

Please post some sample data along with expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[SkiliedSin]

Apologies for the super confusing request, I meant to say that the start month/day matters but to disregard the year to an extent.

I've attached another image showing what I'm looking for, please let me know if this makes any sense.

Edit: As you an see, if you edit the start date, you'll have a different number of months that it was running through.

 

[Fluff]

Maybe

=MONTH(B$1)-MONTH($A2)+1

In future please post sample data not an image.

 

[Joe4]

Place this in cell B2 and copy to all cells in your grid:

=MAX(MONTH(B$1)-MONTH($A2)+1,0)