4 Replies Latest reply on Dec 9, 2014 8:20 AM by Jerry Pudmanski

    dates

    Jerry Pudmanski

      I have two questions on the attached worksheet.

       

      1. on the first tab "months open" the formula months open does not seem to calculate correctly and I can't figure out why.   I am trying to take the difference between the open date and my parameter in months. In some cases the formula works but not in all cases.

       

      2.  On the second tab i want to show a revenue per sq ft for locations open at least 18 months. This means each year the numbers of locations included in the calculation should change. I can't fugure a way to do this without having a different tab for each year.

       

      Any ideas?