Name all days between two date values

[chillyrose]

Hi guys

Wonder if anyone can help me please?

I am creating a spreadsheet to monitor employees sickness habits, including their patterns of sickness, i.de do they often take Fridays and Mondays off?

In my spreadsheet I have two columns, one with the first date of absence, and another with the last date of absence.

Does anyone know of a formula that will list all the days of the week as text that that person would have been absent for?

Thanks in advance

 

[cronchetto]

Many thanks!

 

[cronchetto]

When I use this formula:
=IF(C$2="","",SUMPRODUCT(--(TEXT(ROW(INDIRECT($A3&":"&$B3)),"ddd-mmmm")=C$2&"-"&C$1)))

When I put copy this formula (in array formatt) across my months and if I have a start date of say 11/20 to 12/20, still get values for October.

Any thoughts???

 

[cronchetto]

Nevermind - ignore the above question