Create Function For Entire Column Indefinitely

[JBark]

Hi,

I already have a worksheet which uses this calculation:

=DATEDIF(B:B,H:H,"MD")

In most cases it is in different rows like (B:B2, H:H2, "MD") but I want it
to INDEFINITELY calculate for the entire row without having to drag-copy to
add more rows at the end of my worksheet.

I tried to select the entire column and insert/paste =DATEDIF(B:B,H:H,"MD")
into the entire column, but it still only places the calculation in the first
row. Am I doing something wrong?

 

[Bernard Liengme]

You cannot use =DATEDIF(B:B,H:H,"MD") since the arguments must be cells not
ranges
Two options:
a) Select the range into which you want to put the formula. I will assume if
begins on row 2. Tpe =DATEDIF(B2,H2,"MD"), and commit the formula with
CTRL+ENTER to fill the range

b) If you have typed =DATEDIF(B2,H2,"MD) in a cell where the column to the
left if full of data (ie part of a table of data), then rather than dragging
the fill handle, just double click it

best wishes