Thank you very much! i didn't think to use a function, i do already have a date dimension table.

the solution worked using the following code for those who need as well

SELECT guest_name,start_date,end_date

FROM hotel_guests t1

CROSS JOIN (SELECT date FROM date_table) t2

WHERE t2.date >= t1.start_date and t2.date <= t1.end_date