Finding the difference in days between two dates?

[Damon]

Hi,

I was wondering if anyone could let me know how I can find the difference in
days between two date fields, would appreciate the help.

Thanks

Damon

 

[Mark Rosenkrantz]

Damon;

Just try this.

Enter two dates ( 01/08/2003 and 21/08/2003 )
In another cell subtract the two dates, but format that cell as "General".

If all is well, just must find a 20 in that cell.
Or is it too simple and not what you want ?

Mark Rosenkrantz.

More Excel ? www.rosenkrantz.nl or (e-mail address removed)