Excel Question - Autopopulate a Table with Date Ranges

ricapa

New Member
Joined
May 6, 2015
Messages
1
I have a question...I am bulding a table in Excel which contains on the columns all of the months and in the rows I want to display in automatic the information from another table that I have with all of my contracts (3, 6, 9, 12 months contracts), so basically in my first table I have all of the information regarding when the contract starts and when the contract ends, and I want to auto-populate the income of each month, considering when the contract starts and ends

can someome help me on this question?

thank you
Richard
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,095,929
Messages
5,447,361
Members
405,447
Latest member
WPY

This Week's Hot Topics

Top