I've have a formula that calculates, from a date entry, the number of
days elapsed in that month. E.g. An entry of "20/12/09" will return "20"

With this NG's assistance, I achieve this with =R6-DATE(MONTH(R6),1,0)
in cell T6.

Q. How do I convert the result in T6 to a numeric. I want to add the
days remaining in the month (in cell T6) to a number elsewhere?

At the moment I'm adding a date serial number to a numeric giving a
stupid result.

Tks - Ricky