varDays = Range("D1").Value - Range("C1").Value

hth
Rowan

"Daniel" wrote:

how to get the number of days between two date formatted fields in vba for
excel?