Combine Text & Date Sum Formula

[Melimob]

Hi

I want to say from & to dates based on cell values
I have this formula:
="From "&D$15-SUM(D$14*7)&" To "&(D$15-49)

which returns result
From 43602 To 43651

so to convert serial numbers to date format I tried:
="From "&TEXT(D$15-SUM(D$14*7),DD-MMM-YY)&" To "&TEXT(D$15-49,DD-MMM-YY)

But this returns "NAME error value

Can someone please help? Many thanks in advance!

 

[kweaver]

You need quotes around the "DD-MMM-YY"

 

[Melimob]

You need quotes around the "DD-MMM-YY"

knew it would be something simple! thanks so much!