>Thanks yet again Sergey
>
>I had just got to the point of subtracting the imported number from the actual date in the spreadsheet to give me the base date.
>
>I was puzzling over the fact that it was {12/30/1899},
>instead of the {12/31/1899}, in your routine but I guess one out is not really the problem as long as it works, hehehe.
>

If you take close look you'll see that both of dates are correct. Your's represent the date you've to add to the serialized number to convert it to date. My represents the date corresponded to the serialized number 1. It means, you've to add my date-1 (your's date) to the the serialized number to convert it to date. All my code code cold be by simplified to one line

PARAMETER pvSerNum
RETURN {12/30/1899} + pvSerNum