use datediff:

Text3 = DateDiff("d", DateValue(Text1), DateValue(Text2))

------------------
Mark Sreeves
Analyst Programmer

[email protected]
A BMW Group Company