Page 1 of 1
missed date
Posted: Sat Apr 24, 2021 3:10 pm
by 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
Re: missed date
Posted: Sat Apr 24, 2021 4:09 pm
by 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
Re: missed date
Posted: Sat Apr 24, 2021 6:17 pm
by 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
Re: missed date
Posted: Sat Apr 24, 2021 8:27 pm
by sna
Here is an expected results
Re: missed date
Posted: Sat Apr 24, 2021 9:28 pm
by 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
Re: missed date
Posted: Sun Apr 25, 2021 6:24 am
by sna
Thank you so much