I am using an MDX formula as follows
I don't think it is relevant that this is an MDX formula, not sure.Please Login or Register to view this content.
What I want to do is change this formula so it still executes the same way, but it points to a cell reference to get the date. So what I had in mind is this.
But of course I want the A5 to resolve to the date that is in this cell. I have tried indirect, but can't get that to work. I know I can do this in VBA with something like this.Please Login or Register to view this content.
But I would like to do this with pure standard functions if possible. Any ideas?Please Login or Register to view this content.
Bookmarks