Results 1 to 8 of 8

Calculating Lag Period of 2 Months

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2021
    Location
    Bangkok
    MS-Off Ver
    MS Office 365, Verision 16.55
    Posts
    52

    Calculating Lag Period of 2 Months

    Essentially Row 11 comes from a Rental calculation sheet and it shows the accummulated no. of rooms we are renting in a particular month
    In Month 0 the 3 is rooms is owned by us to its always there and can be rented out immediately
    But for the rooms we are renting if we want to sub lease these rooms, we think it will take at least 2 months to sublease so a lag period of 2 month
    So Row 13 is the Row I want to see the number as in the example (sheet)--- hardcoded
    For examples,

    Month 0 - 3 rooms
    Month 1- 3 rooms
    Month 2- 3 rooms
    Month 3- 5 rooms (2 rooms added from the rooms which were rented in Month 1)


    With Row 13 I can calculate my revenue and expenses so its more important to me.

    I tried various ways but could not come up with a formula to do so. I would really appreciate if any help on this.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating absence period triggers in 6 & 12 rolling months
    By Cyberstu101 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-30-2019, 09:27 AM
  2. Calculating forecasting into months based on from and to period
    By eagleadam89 in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-19-2016, 10:54 AM
  3. Calculating forecasting into months based on from and to period
    By eagleadam89 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2015, 06:05 AM
  4. Replies: 6
    Last Post: 09-06-2005, 03:05 AM
  5. Replies: 6
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-05-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1