Date Formulas

I am looking to set up a Date function.

I have multiple dates on a sheet, I need to set a column or multiple columns up with a formula to automatically calculate.

Example

1 column has a Start date (date column property)

I want another column to calculate 21 days ahead when that will bill, and so on for each 21 days..

Do I make the bill date column a Date property?

What is the formula I use, I have searched but can only find =Date2 =21 which doesn't work because I have multiple dates on a line I need the formula to grab a specific column and count forward.

Thank you for your help and suggestions in advance

Michelle Lambert

Find more posts tagged with

Accepted answers

Jeff Reisman

Yes, make the Bill date column a Date-type column. Then you can just use

=[Contract Start Date]@row + 21

Or if the Day Value may change from row to row, you can use

=[Contract Start Date]@row + [Day Value]@row

All comments

Paul Newcome

Are you able to provide a screenshot for reference?

michelle.lambert

I am looking to add 21 days from the contract Start Date to the first Cycle date column.

Jeff Reisman

Yes, make the Bill date column a Date-type column. Then you can just use

=[Contract Start Date]@row + 21

Or if the Day Value may change from row to row, you can use

=[Contract Start Date]@row + [Day Value]@row

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.