Capturing data in rows for number of days selected in calender

[dss28]

I want to build a data base using a userform1 having say 4 textboxes to input data
textbox1 - Name
textbox2 - address
textbox3 - Start date
textbox4 - end date

the sheet1 where data will be saved will have columnsA as Name, ColumnB as Address, ColumnC as Date.

I want to capture data in sheet1 in such a way that if start date and end date is same, Name, Address and date is captured only once.

If the duration between start date and end date is 3 days (eg. 20/10/2021 to 22/10/2021), then Name, address and date (3 different dates - 20/10/2021, 21/10/2021, 22/10/2021) are captured in the sheet in three rows.

Book1
	A	B	C
1	Name	Address	Date
2	Mr A	XYZ	01-01-2021
3	Mr A	XYZ	02-01-2021
4	Mr A	XYZ	03-01-2021
5	Mr A	XYZ	04-01-2021
6	Mr B	ABC	01-01-2021
7	Mr C	DEF	02-03-2021
8	Mr D	DEF	10-03-2021
9	Mr D	DEF	11-03-2021
10	Mr D	DEF	12-03-2021
11	Mr D	DEF	13-03-2021
Sheet1