date range formula charging different rates for weekends

hello all,

i need a formula that will take the date range as below (i2 through j2) and figures out what is a friday or saturday and charges 200.00 for those days and then every other day gets charged 175.00 a day




I J K L M N
1 check in date check out date days rented days until checkin rent fee
2 08/20/15 08/30/15 10 6 ***here is where i need a formula
3
4


thanks for your help,
scott

Screen Shot 2015-08-14 at 3.02.48 PM.png

here is a screen shot to clearify

Attachment 413692

here is a screen shot to clearify

that worked great, just needed to add two columns for the price per "weekend" and "weekday", is there a way to add that all in one formula?

that is perfect !

thank you very much as i have been racking my brain and just could not find the answer.

thanks again

scott

Screen Shot 2015-08-21 at 8.40.33 AM.png

well i thought that this worked perfect but the weekend rates come out negative as showed in N4, the weekdays seem to work perfect