need help with a formula

[Jenkcaldwell]

I am attaching a spreadsheet that I need help with.  Column L currently calculates 28 days from column K.  I need column L to calculate 27 days from column K. 

[#2]

Column C has to be factored in also. 

[#3]

The values in J6 and J7 are the same, and so with L6 and L7. Please check the accuracy of your data.

[#4]

SOLVED, thanks!