Date Calculations

Hi there,

I am trying to do a simple formula for a date to automatically populate in the Date Due column. I take the Event date and subtract the number of days prior to the meeting for each individual due date. This is the formula I created.

However, when I run this formula in the Date Due column, nothing is returned.

What am I doing wrong?

Thank you,😕

Find more posts tagged with

Formulas

Accepted answers

David Dolch

If you are looking for a date, then do not use the SUM function

=[Board Event Date]@row-[#Days PTM]@row.

All comments

David Dolch

If you are looking for a date, then do not use the SUM function

=[Board Event Date]@row-[#Days PTM]@row.

Mary Pat Aust

Thank you so much. I know formulas can be my friend but they are going to kill me. 😎

David Dolch

You are welcome

They are close, but just different enough from other formula syntax (Excel, SQL, etc) to make me have to go and check syntax every so often myself.

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.