Insert Missing dates and rows if there is no Inventory

[AnanditaShankar]

Hi. I am trying to insert missing dates between 31st Decemeber 2021 till 31st July 2023 when there is no inventory noted on that day. For eg: If Plant Y352 has inventory only on 1st jan and 3rd jan then it should insert a row with missing dates and copy the same information for Y352 for 31st Dec 2021 and 2nd Jan with Inventory as 0 . Attaching an excel with expected input and output

[FinnCharlton]

Hi @AnanditaShankar , here is one way to add all the missing dates. Hope it helps!

[messi007]

@AnanditaShankar,

Another way to do it.

Attached the zipped workflow and batch macro.

[PhilipMannering]

This is how I'd do it,

[AnanditaShankar]

The dates should not be generated just based on Min and max dates but for all the dates between 31st Dec-2021 to 31st July 2023

[PhilipMannering]

Ah, I think @FinnCharlton 's solution does that.

[AnanditaShankar]

No it doesn't. i tried it

[AnanditaShankar]

I checked the count of dates generated across each plant and it's not the same for all

[FinnCharlton · Accepted solution]

@AnanditaShankar if you want it specifically between those dates, you can do it like this:

[AnanditaShankar]

Thanks @FinnCharlton . This is what I wanted.