Aug 22 2022 12:54 AM
helo
I have many columns in my table that i want to calculate. and don't have the time to go one by one.
How do I apply the Dateif for the whole table in the same time?
Aug 22 2022 02:01 AM
Aug 22 2022 02:22 AM
Hi @sivan1985
I assume that you already know how to use the function datadif.
To save time and repeat the formula for the whole column, you would just use the fill down the cells ( write the formula in the first cell, then select the cell, then move the curser on the right low corner until you see a plus sign click and drag down to copy the formula)
Aug 22 2022 03:29 AM
thank you for you good response :)
but what do I do after I drag the + until the end of the collumn? what then shoul I press?