Adding a column to excel depending on the given condition

[MEGHA_cs]

Hi, I have a scenario, where there are two columns in Excel PeriodFrom(mm/yyyy) and PeriodTo(mm/yyyy), I should get difference between months, and bot should add those many months columns at the End of the table.

Ex: PeriodFrom - 01/2023 and PeriodTo - 05/2023, and last column is 01/2023
now bot should get difference as 4months… and it should add columns as 02/2023, 03/2023, 04/2023 and 05/2023 …

TIA.

[Suraj_B_Shetty (Suraj)]

Hi @MEGHA_cs

Give a try to this workflow it matches your requirement.
AddMonthColumn.xaml (10.2 KB)

Output

Hope this helps

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @MEGHA_cs
Ex temp.zip (69.2 KB)
Hope this helps

Cheers.

[MEGHA_cs]

Thanks, its working