missed date

[sna]

Hi Dear
I need your input for the missing dates between dates .
It should return from the date start to finish date but in between day 7th.


Best Wishes
3 Don't 3 Protection
Stay safe

[norkaz]

...

Hi Guy.

To understand properly for things that you are looking for, plesae place some examples the missing dates that retrun betweeen start and finish as you always did.

Please place just only the text or numbers, no need the Excel formula(s) for sample.

Norkaz

[norkaz]

...

Try this,

Daily data B3:B99

D3
=IFERROR(AGGREGATE(15,6,ROW(INDIRECT($B$3&":"&MAX($B$3:$B$99)))/(LOOKUP(ROW(INDIRECT($B$3&":"&MAX($B$3:$B$99))),$B$3:$B$99)<>ROW(INDIRECT($B$3&":"&MAX($B$3:$B$99)))),ROW(1:1)),"")


Does this help?

Norkaz

[sna]

Here is an expected results

[norkaz]

B2

=EOMONTH($A$2,ROW(1:1)*12-ROW($12:$12))+1

C2

=IFERROR(AGGREGATE(15,6,$A$2:$B$22,ROW(1:1)),"")

Norkaz

[sna]

Thank you so much