Calculating days past due when comparing two columns

So I am trying to compare two columns. If the Revised Release Date is blank, then look at Planned Release Date -Baseline and determine how many working days we are past due. If Revised Release Date is not blank, use that field to determine how many working days we are past due.

I've tried this formula as I thought my logic was correct:

=IF(ISBLANK([Revised Release Date]@row), IF([Planned Release Date (baseline)]@row < $today$1, NETWORKDAYS([Planned Release Date (baseline)]@row, $today$1), ""), NETWORKDAYS([Planned Release Date (baseline)]@row, [Revised Release Date]@row))

Find more posts tagged with

Accepted answers

All comments

David Joyeuse

Hi @sbrelage

Try replacing $today$1 with TODAY().

Hope it helped

Sarah Brelage

I'm still getting an unparseable error

=IF(ISBLANK([Revised Release Date]@row), IF([Planned Release Date (baseline)]@row < TODAY(), NETWORKDAYS([Planned Release Date (baseline)]@row, TODAY(), ""), NETWORKDAYS([Planned Release Date (baseline)]@row, [Revised Release Date]@row))

Paul Newcome

Try this...

=NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date - Baseline]@row), $today$1)

Sarah Brelage

Paul - it is still saying Unparseable..I removed the "- Baseline" in the one column heading in case that was causing a problem and still getting the error

Sarah Brelage

Paul Newcome

=NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date]@row), $today$1)

Do you have a column called "today"?

Sarah Brelage

No...

Sarah Brelage

So I replaced the $today$1 with the TODAY function and I believe it is now working

Paul Newcome

That would have been it then.

$today$1 refers to a specific cell in row 1 of a column called "today". If you do not have that, then you would need to use the TODAY function.

Glad it is working for you now. Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.