Date Formula

Enyonam

I have two quick questions;

I need a formular to express the following:

End date of column A = Start date for column B

( I tried setting the columns equal to each other but get an error)

Second formula Column C = Column B +10

( I tried Date1 +10 but get an error)

Find more posts tagged with

Formulas

Accepted answers

All comments

ChloeSmith

Hello,

Can you elaborate on what type of error you're getting? Is it the "Invalid Column Value" one or the "#ERROR" one?

Sameer Karkhanis

First make sure all columns have Column Type as Date.

When you say end date of Column A equal to start date of Column B -- what do you mean by this? If you are saying you just want the date value in Column B to be the same as Column A then just use the formula in Column B as =[Column A]@row

For Column C, once you address the column type mentioned above in line one you should not get the error. If the assumption for Column B is good, then you can as well have the Column C formula as =[Column A]@row + 10

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.