Delta Date

Eric Laitenberger

Hello,

I would like add a formula to add a date delta according a deadline

For example: today 16-JUN-2022, my Deadline = 15-JUN-2022 so delta = +1

Today 16-JUN-2022, My Deadline = 10-JUN-2022. so delta = +6

Could you help me for the formula please

Find more posts tagged with

Accepted answers

Sing C

There might be a simpler approach but this should work:

=IF(Deadline@row < TODAY(), "+" + (TODAY() - Deadline@row), TODAY() - Deadline@row)

Let me know if that helps!

Thanks.

All comments

Sing C

Hi @Eric Laitenberger,

Give this a try and convert it to a column formula:

=IF(Deadline@row > TODAY(), "", TODAY() - Deadline@row)

This leaves the delta column blank for any rows where the deadline is in the future.

Let me know if that helps!

Thanks.

Eric Laitenberger

Hi,

Thanks,

Is it possile to have + "X" when late and -"X" if the deadline is in the future?

Sing C

There might be a simpler approach but this should work:

=IF(Deadline@row < TODAY(), "+" + (TODAY() - Deadline@row), TODAY() - Deadline@row)

Let me know if that helps!

Thanks.

Eric Laitenberger

perfect

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.