Splitting out days to show actual days off -Monday etc

[wozzie]

So i have been asked to create a spreadsheet that shows the days that employees go off. so if they are off on 2nd November will show Wedneday. that is simple enough. Issue i have now is that the spreadsheet that gets thrown to me has the start and end days, so will show 31st October in one cell and 4th November as end date. is there any formula that i can use that will split this out so that will show for those 5 days they were off monday, tuesday, wednesday etc? or is this something of a stupid question.
cheers
Matt

 

[steve the fish]

With dates in A2 and B2:

=TEXT(A2+SEQUENCE(B2-A2+1,,0),"DDD")