Hi, here is 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 Col C Row 1
For e.g. Col A Row 1 is 12/10/2006
Col B Row 1 is 14/10/2006
Type =NETWORKDAYS(B1,A1) in Col C Row 1
You will get the answer 2 days
NOTE: REMEMBER TO FORMAT CELL TO NUMBER FOR COL C ROW
1
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