Calculate Probation period (+2 month)

Hi everyone,

I am working on calculate probation period (2 month) since the start date, I used formula =DATE(YEAR(Startdate@row); MONTH(Startdate@row) + 2; DAY(Startdate@row))

The month was fine except November and December (calculate more but the time did not jump to next year).

Please give me advise for this, thank you so much

Find more posts tagged with

Accepted answers

All comments

Dale Murphy

@phuong Is =[start date] + 30 not close enough?

Dale

phuong

Hi @Dale Murphy ,

I mean, probation period is 2 month ( 60 calendar day), so I add the formula MONTH(Startdate@row) + 2

For Jan -> Oct is okay, but if the start date contain November and December, that would be error (Because the formula not increment in next year)

Ex: 18/11/2022 must be 18/1/2023

Dale Murphy

@phuong Yes, I understand your approach. My suggestion, to avoid a rather complicated formula to check for end of year, is to use simple date math. In fact, startdate() + 60 is a more accurate calculation of 60 calendar days than two months, which will vary from 59 days to 62 days.

Vinithar

If I started probation on 12-06-21 with 24 months what date will it end

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.