Using the difference between dates in an IF statement

I have a column the calculates the number of days between 2 dates, which is fine.

=[Arch Prelims]@row - [FP Arch Engagement ]@row (gives me a number)

But I don't want to do the calculation if the difference is a negative number. There are few instances where the result would be a negative number (very few) I don't want to include values for negative numbers. I tried using an IF statement results in a #UNPARSEABLE error.

=IF([Arch Prelims]@row -[FP Arch Engagement]@row > 0, [Arch Prelims]@row - [FP Arch Engagement]@row, 0)

both of the fields are Dates.

Help!

Find more posts tagged with

Formulas

Accepted answers

Protonsponge

Hello @MarkCep,

You could have a formula that said if [Arch Prelims]@row - [FP Arch Engagement ]@row is less than zero, show blank else, [Arch Prelims]@row - [FP Arch Engagement ]@row. I think that would give you what you are looking for.

=IF([Arch Prelims]@row - [FP Arch Engagement]@row < 0, "", [Arch Prelims]@row - [FP Arch Engagement]@row)

I hope that is helpful to you in some way,

Protonsponge

Nick Korna

@MarkCep, the second formula should work (having tested it) - is it down to the FP Arch Engagement in the first (working) formula having a space at the end of the column and the second formula not?

All comments

Protonsponge

Hello @MarkCep,

=IF([Arch Prelims]@row - [FP Arch Engagement]@row < 0, "", [Arch Prelims]@row - [FP Arch Engagement]@row)

I hope that is helpful to you in some way,

Protonsponge

Nick Korna

@MarkCep, the second formula should work (having tested it) - is it down to the FP Arch Engagement in the first (working) formula having a space at the end of the column and the second formula not?

MarkCep

Thank you, both answers helped solve the issue.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.