Hi, here what you can do.

Step 1: Go to *Tools*--*Add-ins *(check on *Analysis ToolPack-VBA*)
-- click *OK*

Step 2: Keyed in =NETWORKDAYS(B1,A1) on Row 1 Column C


Clash Wrote:
Hi all,

Can someone please help.

I can't work out how to get a formula to work out the difference in
days between two dates.

e.g. 12/10/2006 and 14/10/2006 = 2 days

please help.


--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=538351