Calculating Weeks, Weekday nights and Weekend nights

Hello,
I'm developing a register for a hostel, given two set of dates (check-in and check-out)
i have to calculate the number of weekday nights(Sun-Thu) and weekend Nights (Fri-Sat),i'm really new to excel and i would appreciate any help in doing this.

Thanks in advance,
Av