Formula to apply time loss

[asmith601]

I am stumped with this. I have due dates for my assignments. I would like to apply a 1% penalty for every day they are late. The formula I have been trying to get working is:

=IF(TODAY()>Report!D12,F8-((TODAY()-Report!D12)-((WORKDAY(Report!D12,(TODAY()-Report!D12)))-TODAY()))*0.01)

Report!D12 = Due Date
F8 = % Completed

Basically grabs today's date and the due date, and applies a 1% penalty for each day over. F8 will always be 100%.

Any ideas?

 

[edmitchell]

Hi

any good?
=IF(NETWORKDAYS(TODAY(),D12)<0, -(NETWORKDAYS(TODAY(),D12)*0.01)-0.01,0)