Forum Discussion

JennyHoA20181's avatar
JennyHoA20181
Brass Contributor
May 15, 2020
Solved

Returning values based on Start Date / End Date in a given year

Hello everyone,   I basically have over 200 clients and they each have around 1-5 contracts with us. Each contract has a start date and end date. Each contract has a contract type  and a contract s...
excel
Excel on Mac
Formulas and Functions
Macros and VBA
  • JennyHoA20181's avatar
    JennyHoA20181
    Brass Contributor
    May 16, 2020

    Thank you SO much ice12020 

     

    Really appreciate the help, as I need to complete the task next week for a board level review 😞

     

    Getting so close now!!!!

     

    I have attached 2 examples of the results I expect to see if that helps more?

      • JennyHoA20181's avatar
        JennyHoA20181
        Brass Contributor
        May 17, 2020

        Thank you! ice12020 

         

        I have attached my notes on line 650 regarding the account Eruditus LLC, for further amendments needed - so so close! 

Resources