Just subtract:

A1 = 9/1/2006
A2 = 1/23/2006

=A1-A2

Format as GENERAL or NUMBER

Result = 221

Biff

"DHM" wrote in message
...
How do i calculate the number of days between 3 dates, 09/01/2006 thru
01/23/06