Get rid of #ERROR! in formula field?

[Crissy_Page]

Can someone help me with my formula? I have an “aging” column that I use to show months since the publish date of my blog posts. This works well when I have a publish date, but, for unscheduled posts it returns an ugly #ERROR!

I would like it to either show blank, or N/A. Here’s my formula.

DATETIME_DIFF(TODAY(),{Publish Date},'months')

[Jeremy_Oglesby · Accepted solution]

Just surround the whole thing in a conditional that checks for the presence of a Publish Date:

IF(
   {Publish Date},
   DATETIME_DIFF(
      TODAY(),
      {Publish Date},
      'months'
   )
)