I have a spreadsheet in which row F is the original hire date, and row H is the last check date, I need to insert for row G a project start date based on the following- if the hire date is before 1/1/12 than the start date is 1/1/12, if the hire date is after 1/1/12 than the start date equals the hire date.. I cannot seem to get the formula to correctly show the hire date as the start date when the hire date is after 1/1/12. Pls advise