Excel help

  dobie2 19:25 08 Jun 09
Locked

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 09

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.

AMD Ryzen release date, specifications and features: Three CPUs from the Ryzen 7 range now…

1995-2015: How technology has changed the world in 20 years

Glassworks Barcelona shows how it captured the artistic imagination of Conor in A Monster Calls

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…