Forum Discussion

Copper Contributor

Oct 06, 2021

Solved

iferror and today function

Hi, I'm trying to use both functional ions to calculate duration in a project tracker. My formula is: =iferror(cell b-a,today()-cell a) Reason it's done this way is because i would like a count of t...

Formulas and Functions

Riny_van_Eekelen
Oct 06, 2021
Lizzy2320 Perhaps like this then:
=IF(ISBLANK(A1),"",IF(ISBLANK(B1),TODAY()-A1,B1-A1))

Lizzy2320

Copper Contributor

Oct 06, 2021

Thanks! Isblank won't count accurately if the end date is inputted.

Riny_van_Eekelen

Platinum Contributor

Oct 06, 2021

Lizzy2320 Why not? See attached.

lizzy.xlsx9 KB

Lizzy2320
Copper Contributor
Oct 06, 2021
If the cells are blank it will return a number.
- Riny_van_Eekelen
  Platinum Contributor
  Oct 06, 2021
  Lizzy2320 Perhaps like this then:
  =IF(ISBLANK(A1),"",IF(ISBLANK(B1),TODAY()-A1,B1-A1))
  - Lizzy2320
    Copper Contributor
    Oct 06, 2021
    Thank you! This did the trick 🙂