How to update Formula to include "End_Date"

[malawimick]

I want to put an end date in "G3" and update the formula in "Column C" to reflect this.
How can I do this, please?
Any help greatly appreciated - thank you!Mem_Pay_Test.xlsx

[malawimick]

Hi Guys,
Do I have enough info here for this question to be answered?

[Haseeb Avarakkan]

Try this,

=IF(OR(A8="",G$5>G$3),"",((G$5-G$2+1)*(G$4/5))-D8)

Converted weekly rate to daily (assume 5 days per week). If some one is not worked a full week, payment reduced to how many days worked on a week.

[malawimick]

Thanks for yourhelp Haseeb
I need to rethink what I am doing