Excel help

  dobie2 19:25 08 Jun 2009

Hi Guys

Looking for an Excel formula. In column one is a date, lets say 01/06/09. In the next column I am looking for a formula which will automatically calculate how many days since the date in column 1.

Thanks in advance

Debs XXX

  Eric10 19:46 08 Jun 2009

Format column B as Number with 0 decimal places. In B1 enter =TODAY()-A1 then copy the formula down the column.
If you want the cells in column B to be blank until a date is entered in the appropriate cell is column A then use =IF(ISBLANK(A1),"",TODAY()-A1).

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?