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?
=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?