Skip to main content

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 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    May 30, 2024, 11:56 AM

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

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