No problem thnx for the posting tip, good idea, I'll do that shortly...

however got this answer from another forum & it works perfectly. . 🙂

select dateadd(dd, n.number, h.StartDate)

from master..spt_values n

join PublicHols h on n.type = 'P'

and dateadd(dd,n.number,StartDate) between h.StartDate and h.EndDate