I've got a dynamic named range called CustomerSince
. I used following formula but, as you can see on the picture and on the attached spreadsheet, it doesn't work properly. The formula should add only those cells into the named range that have a value.
Furthermore, I am trying to determine the date when the customer first orderer something from the company. I used following formula:
Where 1 is for January etc. But this formula doesn't work either. Is it because the named range is screwed up?
Thanks for your help