Salam;
as per my understanding, total fee k cell m ya formula lagain. aap ki sheet k mutabiq jo k cell P5 ha
Code:
=MONTH(TODAY())*500
ya formula system k date k sath aap ka month check kare ga k konsa ha. aur phr us ko 500 jo k aap ki monthly fees ha us sa multiply krega. is trah aap ko us month tak ki total fees de dega.
Deposit k columns m aap sum ka formula lagain,jo tamam months ko cover kare.
Aap ki baqi columns m formula thk hain. Hope this will help.
Note: New month start hone par aap ko apne sheet manually calculate krne ho gi. jo k aap F9 ya shift+F9 press kar k kar sakte hain. aur aap ki sheet update ho jae gi.
regards,
Bookmarks