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! 

      • peteryac60's avatar
        peteryac60
        Iron Contributor
        May 17, 2020

        JennyHoA20181 

        Jenny

         

        I have reformatted the dates in column C to numbers. So when you check line 651 (for example) you can see that the number is greater than the one in U5 which is why you don't get the result you expect.

         

        I suspect that the date setting on your computer might be different to mine? Are you in the US?

        If you go to the windows settings you should be able to see what settings you have. If they are US then the dates are likely to be in mm/dd/yy format which will give you a different number to dd/mm/yy.

         Check that first and see how you get on.

         

        Peter

         

         

Resources