You just subtract

Dim a As Date, b As Date
a = #6/1/2004#
b = #6/10/2004#
MsgBox b - a

cogent wrote:

Hello

I must be bleary eyed. Is there a VBA function which counts the number of
days between two dates (as in the workbooks)?

W