Why not just this...

=ABS(B1-A1)

instead?

Rick


"Gary''s Student" wrote in message
...
if the dates are in A1 and B1, then

=MAX(A1,B1)-MIN(A1,B1)
--
Gary''s Student - gsnu200764


"tc" wrote:

hi. i need to create a macro that will alow me to find the difference
in days between two given dates. is this possible?
thanks