Hi! Is there anyway I can get this result?

A1 = Check-in Date
B1 = Check-out Date (isn't counted)
Room rate on Sun, Mon, Tue, Wed = 100
Room rate on Thu, Fri, Sat = 110
C1 = Sum of the Room rates

For example
5/12/2014 Fri 110
6/12/2014 Sat 110
7/12/2014 Sun 100
8/12/2014 Mon 100
9/12/2014
Sum 420

Display in the worksheet
A1 B1 C1
5/12/2014 9/12/2014 420

Sorry, I don't know how to explain better than this.