need help with a formula

Highlighted
New Contributor

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. 

 

 

3 Replies
Highlighted

Column C has to be factored in also. 

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

SOLVED, thanks!