<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic If you use excel to track your progress... Small Tip/Trick in General Credit Topics</title>
    <link>https://ficoforums.myfico.com/t5/General-Credit-Topics/If-you-use-excel-to-track-your-progress-Small-Tip-Trick/m-p/222208#M102287</link>
    <description>Here is a good formula for calculating the 7.5yr Date based on the DOLA date.&lt;BR /&gt;in my case my DOLA date is stored in cell (O3) just replace the three O3's with the cell that your date is stored in:&lt;BR /&gt;&lt;BR /&gt;=DATE(YEAR(O3)+7,MONTH(O3)+6,DAY(O3))&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;if you only want to calculate 7yrs just remove the +6&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Hope this is helpful!&lt;BR /&gt;&lt;BR /&gt;Message Edited by nosxih on &lt;SPAN class="date_text"&gt;04-26-2008&lt;/SPAN&gt; &lt;SPAN class="time_text"&gt;10:43 PM&lt;/SPAN&gt;</description>
    <pubDate>Sun, 27 Apr 2008 05:43:43 GMT</pubDate>
    <dc:creator>nosxih</dc:creator>
    <dc:date>2008-04-27T05:43:43Z</dc:date>
    <item>
      <title>If you use excel to track your progress... Small Tip/Trick</title>
      <link>https://ficoforums.myfico.com/t5/General-Credit-Topics/If-you-use-excel-to-track-your-progress-Small-Tip-Trick/m-p/222208#M102287</link>
      <description>Here is a good formula for calculating the 7.5yr Date based on the DOLA date.&lt;BR /&gt;in my case my DOLA date is stored in cell (O3) just replace the three O3's with the cell that your date is stored in:&lt;BR /&gt;&lt;BR /&gt;=DATE(YEAR(O3)+7,MONTH(O3)+6,DAY(O3))&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;if you only want to calculate 7yrs just remove the +6&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Hope this is helpful!&lt;BR /&gt;&lt;BR /&gt;Message Edited by nosxih on &lt;SPAN class="date_text"&gt;04-26-2008&lt;/SPAN&gt; &lt;SPAN class="time_text"&gt;10:43 PM&lt;/SPAN&gt;</description>
      <pubDate>Sun, 27 Apr 2008 05:43:43 GMT</pubDate>
      <guid>https://ficoforums.myfico.com/t5/General-Credit-Topics/If-you-use-excel-to-track-your-progress-Small-Tip-Trick/m-p/222208#M102287</guid>
      <dc:creator>nosxih</dc:creator>
      <dc:date>2008-04-27T05:43:43Z</dc:date>
    </item>
  </channel>
</rss>

