Days between a period!

Hi All,

Hope all is well.

I would like to ask for some suggestions concerning formulas with dates.

Basically I have an excel where:
- on cell A1, I insert a date e.g. 01.01.2016 a
- on cell A2, I insert a second date, e.g. 05.01.2016
- on cell A3, I insert the day of the week, e.g. Monday

I would like to insert a formula in cell A4 which can be dragged throughout and which, when dragged,would fill the other cells with all Mondays falling due between cell A1 and A2.

Do you have any suggestions or ideas for the above if this can be done?

Appreciate a lot your kind help!

Thanks

Keibri

If in A3 you enter number (1,2,3...7 for Mon, Tue, ... Sun respectively) then you could use:

Formula:

Please Login or Register  to view this content.

confirmed with ctrl+shift+enter (not just enter)

Sorry, this will give you just number of how many monday there is.

This will give you all mondays:

Formula:

Please Login or Register  to view this content.

Amazing!! That's really really helpful and what I was looking for !!!

I am not sure if maybe I am asking too much but would it also be possible to to the same depending on the what data you put in cell A3. E.g. Cell A3, can be any other day of the week? (Monday, Tuesday, Wednesday etc)

Not sure if i am asking too much but thanks a lot for your kind help!! Really appreciate it!

Hi Thanks Tony and zbor!

it works awesome!! Thanks a lot!

I was just wondering, if possible, if I need to insert Tuesday instead of Monday, how would the formula change please?

Really great thanks!