Very simple question about Functions, please help

  • Thread starter Thread starter maximilian
  • Start date Start date
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
 
Andy said:
*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 *
Click to expand...

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

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.
 
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
 
tnx that worked

but B - TODAY() doesnt.

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

its doing:

2-1-2003 - Today()
 
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
 
only thing I get = ###############

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

Rgds,
Andy
 
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?
 
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.
Click to expand...

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

Rgds,
Andy
 
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
 
Back
Top