software

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.--
Clash
------------------------------------------------------------------------
Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
View this thread: www.excelforum.com/showthread...hreadid=538351
Hi, here what you can do.

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

Step 2: Keyed in =NETWORKDAYS(B1,A1) on Row 1 Column CClash Wrote:
gt; Hi all,
gt;
gt; Can someone please help.
gt;
gt; I can't work out how to get a formula to work out the difference in
gt; days between two dates.
gt;
gt; e.g. 12/10/2006 and 14/10/2006 = 2 days
gt;
gt; please help.--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: www.excelforum.com/member.php...oamp;userid=30384
View this thread: www.excelforum.com/showthread...hreadid=538351
Hi, here is what you can do.

Step 1: Go to *Tools*--gt;*Add-ins *(check on *Analysis ToolPack-VBA*)
--gt; 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:
gt; Hi all,
gt;
gt; Can someone please help.
gt;
gt; I can't work out how to get a formula to work out the difference in
gt; days between two dates.
gt;
gt; e.g. 12/10/2006 and 14/10/2006 = 2 days
gt;
gt; please help.--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: www.excelforum.com/member.php...oamp;userid=30384
View this thread: www.excelforum.com/showthread...hreadid=538351=A1-A2

Format as General, not as date (which is what Excel does automatically)

--
Kind regards,

Niek Otten

quot;Clashquot; gt; wrote in message
...
|
| 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.
|
|
| --
| Clash
| ------------------------------------------------------------------------
| Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
| View this thread: www.excelforum.com/showthread...hreadid=538351
|
Just =Cell2-Cell1
but format the result cell as General!
Regards
Stefi?lash??ezt ?rta:

gt;
gt; Hi all,
gt;
gt; Can someone please help.
gt;
gt; I can't work out how to get a formula to work out the difference in
gt; days between two dates.
gt;
gt; e.g. 12/10/2006 and 14/10/2006 = 2 days
gt;
gt; please help.
gt;
gt;
gt; --
gt; Clash
gt; ------------------------------------------------------------------------
gt; Clash's Profile: www.excelforum.com/member.php...oamp;userid=18951
gt; View this thread: www.excelforum.com/showthread...hreadid=538351
gt;
gt;