Generate list of dates between two dates

[abdumon7]

I would like to get a list of dates between my date range (B2 - D2) in Column H for first 5 chargeable days date , and Column I for the rest.

Cost slab is

1-10 Free
11-15 20 USD
16-99999 40 USD


I don’t how difficult this is. It would very helpful to me if someone would me assist with this.

[AliGW]

Not enough detail. Why is the first data in the list 15/06? Where did that come from?

[abdumon7]

First 10 days Free (till 14/06/2018)
Next 5 Days 20 USD per day (From 15/06/2018 - 19/06/2018)
After that 40 USD per day (From 20/06/2018 -

[José Augusto]

Hi

Try this in H3 and copy down

Please Login or Register  to view this content.

Try this in I3 and copy down

Please Login or Register  to view this content.

[abdumon7]

Column H3 is working fine. but Column I doesn't generate the full list of dates if I change the date in D3

[AliGW]

In H3:

=IF(ROWS($B$3:$B3) < DATEDIF(B$3,D$3,"d")-20,10+$B$3+ROWS($B$3:$B3),"")

and in I3:

=IF(ROWS($B$3:$B3) < DATEDIF(B$3,D$3,"d")-14,15+$B$3+ROWS($B$3:$B3),"")

[abdumon7]

Sorry. I couldn't check yesterday.

However its working properly. Thanks for your help

[AliGW]

You're welcome!