Forum Discussion

Lizzy2320's avatar
Lizzy2320
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's avatar
    Riny_van_Eekelen
    Oct 06, 2021

    Lizzy2320 Perhaps like this then:

    =IF(ISBLANK(A1),"",IF(ISBLANK(B1),TODAY()-A1,B1-A1))

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 06, 2021

Lizzy2320 Perhaps something like this:

=IF(ISBLANK(B1),TODAY()-A1,B1-A1)

Using IFERROR makes no sense as there will not be an error. Just a TRUE or a FALSE. This formula will check if B is empty. If so, todays date, minus A, otherwise B minus A. 

  • Lizzy2320's avatar
    Lizzy2320
    Copper Contributor
    Oct 06, 2021
    Thanks! Isblank won't count accurately if the end date is inputted.
      • Lizzy2320's avatar
        Lizzy2320
        Copper Contributor
        Oct 06, 2021
        If the cells are blank it will return a number.

Resources