Display negative for past days and positive for upcoming days

I've got a sheet with a "Start" column and a "Today" column. I want this formula;

=NETDAYS(Start25, TODAY25)

To display the number of days as a negative if the Start was prior to TODAY or as a positive if the Start is after TODAY.

Currently, my displayed results are opposite to that.

Find more posts tagged with

Formulas

Accepted answers

David Tutwiler

You should be able to just add a - before the statement. Also, I found in testing that to get a true date you have to add a +1, otherwise the same day will give you a value of 1 or -1. Below is the formula I got to work.

=-NETDAYS(Start@row, Today@row) + 1

All comments

David Tutwiler

=-NETDAYS(Start@row, Today@row) + 1

Michael Macygin

David, thanks so much. This fixed my issue perfectly. I truly appreciate your assistance!

David Tutwiler

No problem. Glad you got it working.

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.