Skip to main content
Sagar Singhal (Barclays) 님이 #Formulas에 질문했습니다

I want to create a row level formula on a report where I need to calculate age between two fields One Completed date - created date ...but if the completed date is blank it needs to be calculated as Today- Created date is it possible..?? and if yes .. please write the formula; 

답변 10개
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2024년 5월 30일 오전 11:56

    I got the dates mixed up, try this (or Helene's answer, same result):

    BLANKVALUE(CompletedDate, TODAY())-DATEVALUE(CreatedDate)