Linking revenue to a specific month

I have a list of months on a sheet flowing to the right.

I also have a list of 10 revenues. I am making a template and want a user to simply type in the date of the expected revenue next to the corresponding revenues and have that information automaticall update below the month it falls in.


Thank you

Hello,

Would you mind posting or attaching an example?

Corine

I am trying to make a spreadsheet for an income property. Except not all of the tenants are currently in the building. I have an acquisition date of (In this format) 3/1/2008.

The template is automatically set up to continue for 5 years in a monthly patern. Ex 3/1/2008, 4/1/2008 etc....(Using edate,1)

I have a list of tenants who are going to start occupying the building throughout the year at different dates. I have columns side by side. EX:
Tenant, Monthly Revenue, Lease Start Date.

I want the monthly revenue of each tenant to automatically flow into the lease start date. The month to month calander will be below the tenant plug-ins and each tenant will have their own calander.

All dates will start on the first of the month.

At the end I will role these up into a yearly calander...but I know how to do that.


Thank you

I would attach a file but I do not know how.

Hello,

To attach a file, go to the bottom part of the post reply screen, do you see the Additional Options -> Attach File --> click the Manage Attachment button. Before uploading the file be sure to compress(zip) the file first.

Corine