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.
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.
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
Originally Posted by Clash
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
Originally Posted by Clash
=A1-A2
Format as General, not as date (which is what Excel does automatically)
--
Kind regards,
Niek Otten
"Clash" <[email protected]> wrote in message
news:[email protected]...
|
| 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: http://www.excelforum.com/member.php...o&userid=18951
| View this thread: http://www.excelforum.com/showthread...hreadid=538351
|
Just =Cell2-Cell1
but format the result cell as General!
Regards
Stefi
„Clash” ezt *rta:
>
> 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: http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=538351
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks