# prob dates

#### aivijardin_09

##### New Member
Good Day Again...

I want to get the exact regularization date of each employee within 6 months. What would be the best formula for these scenario.

A B C D
1 Emp no. Hire Date Status Reg Date
2 12 13-Jan-00 Probation ?
3 13 14-Dec-10 Probation ?
4 14 15-Jan-11 Probation ?
5 15 12-Feb-11 Probation ?

Thanks so much to all!

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### VoG

##### Legend
Perhaps

=DATE(YEAR(B2),MONTH(B2)+6,DAY(B2))

#### aivijardin_09

##### New Member
I don't know how to add it if the 6 months if the given data was date.

Replies
2
Views
180
Replies
2
Views
37
Replies
1
Views
191
Replies
7
Views
167
Replies
1
Views
203

1,190,603
Messages
5,981,890
Members
439,743
Latest member
KatieO

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back