Cubevalue cell referencing

[mdrew9]

Can't seem to get this to work
WORKS:
=CUBEVALUE("PowerPivot Data",Slicer_Project,"[DimDate].[Week End Date].[9/7/2013]","[Measures].[Planned Hours]")

DOESN'T WORK??
=CUBEVALUE("PowerPivot Data",Slicer_Project,"[DimDate].[Week End Date].["&D27&"]","[Measures].[Planned Hours]")

 

[RoryA]

Untested but maybe:
=CUBEVALUE("PowerPivot Data",Slicer_Project,"[DimDate].[Week End Date].["&TEXT(D27,"m/d/yyyy")&"]","[Measures].[Planned Hours]")