Rental Late Charges and Monthly Rent

woodier · Feb 21st, 2002, 07:06 PM

I have a program in which I have listed the daily late charge,the beginning balance,the beginning date,the payment date,the payment amount, No. days of late payments, the late charge amount, payment minus the late charge, and the balance due. How do I add the monthly rental charge on the 1st of each month? Thank you in advance.

Chris Davison · Feb 22nd, 2002, 01:21 PM

Hi Woodier,

when you say "a programme" do you mean just a normal worksheet rather than any VBA "programming" ?

is it easy for you to copy a few rows of your spreadsheet - we can then look at the structure and formulae and see what needs to be done

but basically, if it involves numbers / dates and/or logic then yes, it can be done

cheers mate
Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 07:06 PM	#1
woodier New Member Join Date: Feb 2002 Posts: 8	I have a program in which I have listed the daily late charge,the beginning balance,the beginning date,the payment date,the payment amount, No. days of late payments, the late charge amount, payment minus the late charge, and the balance due. How do I add the monthly rental charge on the 1st of each month? Thank you in advance.

Feb 22nd, 2002, 01:21 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi Woodier, when you say "a programme" do you mean just a normal worksheet rather than any VBA "programming" ? is it easy for you to copy a few rows of your spreadsheet - we can then look at the structure and formulae and see what needs to be done but basically, if it involves numbers / dates and/or logic then yes, it can be done cheers mate Chris