Hello,
I am trying to do a vacation accrual worksheet base off of a start date, or the first of the year. So I need the cell to populate either the hire date or 1/1/18 if they have already been employed for one year.
So in Cell B5 I have the hire date in cell C5 I have the termination date (or a date in the far future) in cell D5 I need it to populate either the hire date or 1/1/18, but if they are terminated I need it to post the termination date.
Can anyone help with this formula?

I am trying to do a vacation accrual worksheet base off of a start date, or the first of the year. So I need the cell to populate either the hire date or 1/1/18 if they have already been employed for one year.
So in Cell B5 I have the hire date in cell C5 I have the termination date (or a date in the far future) in cell D5 I need it to populate either the hire date or 1/1/18, but if they are terminated I need it to post the termination date.
Can anyone help with this formula?

