How to count occurrences between dates on different columns?

Greetings,

I have been scratching my head and I am uncertain how to solve this.

I have a table of information (also attached):

Stage Start Date End Date
1 9/21/2017 4/1/2018
2 4/1/2018 9/2/2019
2 9/2/2019 9/2/2019
3 9/16/2019 1/18/2021

But I need to have it calculate a response like this:

Date Stage 1 Stage 2 Stage 3
9/17/2019 0 0 1
9/18/2019 0 0 1
9/19/2019 0 0 1
9/20/2019 0 0 1
9/21/2019 0 0 1


What formula needs to be used to capture the frequency of occurrences based on the date between two dates in different columns? Any help would be greatly appreciated.

Thank you and I look forward to your reply.

Signed,
John

G2=COUNTIFS($B$2:$B$5,"<="&$F2,$C$2:$C$5,">="&$F2,$A$2:$A$5,TRIM(SUBSTITUTE(G$1,"Stage",""))+0)

Copy across and down

Thank you Caracalla, that solved it. I appreciate the assist.