Post Update***
I formulated the entire sheet and just used "Month 1" until term of contract because i couldn't figure out how to get it to auto populate reading the contract start date. Once I solved that issue now i cant figure out how to to pull the data onto a new sheet that will separate the rows/data by actual month and year for all contracts. Anyone know of a formula or pivot for me to show that?
ORIGINAL POST***
So - I have a "patient" contract start and end date with total treatment cost and a discount column. I formulated the top line and dont know how to auto-populate the remaining data by recognizing the dates of the contract. There are additional notes on the "instruction tab". I just don't know the best way to get the results i need.
I appreciate any help offered.
Excel 101 user here... I have exhausted hours trying to get this to populate and I have faceplanted into failure.
Bookmarks