{"id":8429,"date":"2021-11-28T11:15:03","date_gmt":"2021-11-28T11:15:03","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=8429"},"modified":"2021-11-28T11:15:24","modified_gmt":"2021-11-28T11:15:24","slug":"solved-excel-formula-rent-date","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-formula-rent-date\/9951.html","title":{"rendered":"Solved Excel: Formula Rent$ = Date"},"content":{"rendered":"<p>My knowledge of excel is limited.<br \/>\nI want to set up a simple spreadsheet template for rent received. I have tenants who may chose to pay rent weekly, fortnightly or monthly.<br \/>\nStart with a cell that says their rent is xxx.xx ($300) pw<br \/>\nSay their rent is $300 per week.<br \/>\nIn column A I enter date rent received.<br \/>\nThe period starts on say 1st March 2010 (to be shown as 01\/03\/2010 european format) and $300 would pay their rent up to 07\/03\/2010. So that when I enter 300 in cell B1 it shows up as (paid to) 07\/03\/2010 in the adjoining cell C1. If they paid 320.50 it would show up as (a credit) of 20.50 in the next adjoining cell D1 and if they paid 280 it would show as -20 in D1.<br \/>\nIf they paid 620 on 01\/03\/2010 it would show rent paid to 14\/03\/2010 C1 and a 20 credit in D1.<br \/>\nAlso in colum E a running total of colum D which would show if they had any accumulated credit or debit.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[53],"question_tags":[],"class_list":["post-8429","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/8429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=8429"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=8429"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=8429"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=8429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}