If function to establish a month between a closure date

[Anonymous]

Hi,

I need to establish a month between a closure date.

	Start	End
January	21/12/2020	20/01/2021
Febraury	21/01/2021	20/02/2021
March	21/02/2021	20/03/2021
April	21/03/2021	20/04/2021
May	21/04/2021	20/05/2021
June	21/05/2021	20/06/2021
July	21/06/2021	20/07/2021
August	21/07/2021	20/08/2021
September	21/08/2021	20/09/2021
October	21/09/2021	20/10/2021
November	21/10/2021	20/11/2021
December	21/11/2021	20/12/2021

And this related to a column of month.

I hope you can help.

Cheers!

[v-luwang-msft]

Hi @Anonymous ，

Could not download form the link you shared.

Best Regards

Lucien

[VahidDM]

Hi @Anonymous 

Can you add a result table that you are looking for?

Appreciate your Kudos!!

[Anonymous]

I have attached a file which shows what I need to do. The idea is to incorporate and if function or a function which searches the date on column A and contrast it between the dates from columns from E to G and return the correcto month which is on column E.

You can download the workbook through this link https://gofile.io/d/Uh9yab

I will be waiting for your response.

Cheers!.

[Ashish_Mathur]

Hi,

Try this calculated column formula in the Data Table.

Month = CALCULATE(MAX(Dates[Month]),FILTER(Dates,Dates[Start]<=EARLIER(Data[Programmed Date])&&Dates[End]>=EARLIER(Data[Programmed Date])))

Hope this helps.