Formula within a formula

Laurie

Good afternoon everyone,

I was wondering if it is possible to do an IF formula with a date formula in the same cell?

I would like to do the following, but also subtract the number of working days between two dates.

IF(Status@row "Complete", 0, .....

Below is the formula I have now.

Find more posts tagged with

Formulas

Accepted answers

All comments

Thinh Huynh

HI @Laurie ,

I was wondering if it is possible to do an IF formula with a date formula in the same cell?

Yes, of course you can can. Try this formular:

=IF(Status@row="Complete"; 0; [End Date]@row - [Start Date]@row)

Hope it helps!

Laurie

Hi Thinh,

I tried this but it came back with UNPARSEABLE. Do you have any other suggestions?

Actually, I went back in and saw you put semi-colons, so I replaced those with commas and it worked great! Thank you!

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.