Very simple question about Functions, please help

[maximilian]

I have 2 Date Columns. Column A and B

I want Column C to show the difference of B – A
And I want Column D to show the difference of B – NOW

I know this is simple, please help me out, I’m going mad.


Pic:
http://www.theforumisdown.com/uploadfiles/0103/Openinnewwindow.JPG

 

[Andy Brown]

In C1, =B1-A1 ; in D1, =TODAY()-B1

This'll give you the answers in days, though you'll probably have to format
the cells as General (Format -- Cells -- Number).

HTH,
Andy

 

[maximilian]

*In C1, =B1-A1 ; in D1, =TODAY()-B1

This'll give you the answers in days, though you'll probably have to
format
the cells as General (Format -- Cells -- Number).

HTH,
Andy *

yes but that means i have to write a function for each row. there are
like 10000!

is there a way to have them all done with one forumla

the rows Begin at 5

so I'll have to do:
C5, =B5-A5
C6, =B6-A6
C7, =B7-A7
...

etc


And The numbers of rows isnt constant, so everyday it may varry.

 

[Andy Brown]

Once you've written C1 and D1, select them both (click'n'drag). A small
black square should appear at the bottom right of D1, this is the Fill
Handle. Hover over it till the cursor turns to a black cross, then either
click'n'drag it down or double-click it.

Rgds,
Andy

 

[maximilian]

tnx that worked

but B - TODAY() doesnt.

only thing I get = ###############

its doing:

2-1-2003 - Today()

 

[maximilian]

why Cant I use the function DATEDIF.

I type: =DATEDIF(B6,A6, "d")

but it says that A6 is wrong or something?

i'm using excel 2000 btw

 

[Andy Brown]

only thing I get = ###############

Alternatively, your column(s) may be too narrow, but with that many hashes
it's unlikely.

Rgds,
Andy

 

[maximilian]

ok that worked tnx

but is it also posible to see how many days, instead of days and
months?


so when I do Today() - 2-1-2003 I get "15-9"

I change the format cell to only day, but then I'll just see 15.

can Excel calculate the nummer af all the days?

 

[Andy Brown]

but is it also posible to see how many days, instead of days and

months?
I change the format cell to only day, but then I'll just see 15.

Perhaps you could try formatting the cell(s) as General, as originally
suggested.

Rgds,
Andy

 

[maximilian]

nope that didnt work

cant I do something with NETWORKDAYS.

 

[maximilian]

Hey thnx, I'm alomost done

I have this now:

=NETWORKDAYS(TODAY()-A1)

or

=NETWORKDAYS(B1-A1


but ofcourse that doesnt work perfectly right,

could you tell me how I can get that working

A1 = 2-1-2003 and B1 = 19-2-2003

if I do B1 - A1 I get : 48 days

but I want that to be network days