# Calculate Probation period (+2 month)

Options
✭✭

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).

• ✭✭✭✭✭✭
Options

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

Dale

• ✭✭
Options

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

• ✭✭✭✭✭✭
Options

@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.

dm

• ✭✭
Options

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